求出每隔指定行数的和 (10292)

C2:C7=SUM(OFFSET(A$2,(ROW(A1)-1)*F$1,,F$1))

D2:E2 下拉 {=INDEX(PERCENTILE(SUBTOTAL(9,OFFSET($A$2,(ROW(A1)-1)*$F$1,,ROW(INDIRECT("1:"&$F$1)))),{1,0}),COLUMN(A1))

B2:B23=SUM(OFFSET(A$2,INT((ROW(A1)-1)/F$1)*F$1,,MOD(ROW(A1)-1,F$1)+1))

格式化 A2:B23=MOD(INT((ROW(A1)-1)/$F$1),2)