在B1中输入公式:=SUM(INDIRECT("A"& (ROW(A1)-1)*12+1 &":A" &ROW(A1)*12))然后往下拖即可。或者=SUM(OFFSET(INDIRECT("A"&(ROW(A1)-1)*12+1),0,0,12,))