EXCEL 计算 固定间隔列 平均值答:B12 =SUMIF(OFFSET($A$3,,MATCH(B$11,$B$1:$AK$1,0),,6),"成 绩",OFFSET($A$3,MATCH($A12,$A$4:$A$8,0),MATCH(B$11,$B$1:$AK$1,0),,6))/3 向下向右复制 B19=RANK(B12,B$12:B$16)
excel 每10行求平均值 求公式答:INDIRECT("a2:a"&RIGHT(MATCH(8^4,A:A),1))),AVERAGE(INDIRECT("A"&INT((ROW(A10)-RIGHT(MATCH(8^4,A:A),1)+1)/10)*10+RIGHT(MATCH(8^4,A:A),1)-9&":A"&INT((ROW(A10)-RIGHT(MATCH(8^4,A:A),1)+1)/10)*10+RIGHT(MATCH(8^4,A:A),1)))效果如下图所示: