excel 每10行求平均值 求公式答:公式为:=IF(ROW()<=--RIGHT(MATCH(8^4,A:A),1),AVERAGE(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)...