COUNTIF函数就行啦
G3单元格键入 =countif(B:B,"一组")G5单元格键入 =averageif(B:B,"一组",F:F)
=COUNTIF(B:B,B3)下边那道题 求1组平均值 也把答案给我你=AVERAGEIF(B:B,B3,F:F)
=countif(b3:b12,"一组")
