=SUM(INDIRECT("A" & 5*(ROW()-1)+1 & ":A" & 5*ROW()))
=SUM(INDIRECT("A" & 10*(ROW()-1)+1 & ":A" & 10*ROW()))
还得问您一个问题：递推公式:B1=SUM(A1:A5),B2=SUM(A6:A10),每次加5,以此类推,公式是什么?
要是每次加10呢,公式又是什么样的?
=SUM(INDIRECT("A" & 5*(ROW()-1)+1 & ":A" & 5*ROW()))
=SUM(INDIRECT("A" & 10*(ROW()-1)+1 & ":A" & 10*ROW()))