假设数据在A列在B1单元格输入公式=sum(offset(a$1:a$12,row()*12-12,))下拉填充即可
=SUM(OFFSET(D$2:D$13,ROW(A1)*12-12,))或者这样也行：=SUM(INDIRECT("D"&(ROW(A1)*12-12+2)&":D"&(ROW(A1)*12+1)))
