任意单元格中输入=AVERAGE(OFFSET(AN$1:AN$60,ROW(A1)*60-60,))下拉
在第一个单元格输入=AVERAGE(INDIRECT("AN"&ROW(A1)*60-60+1):INDIRECT("AN"&ROW(A1)*60))向下