如题所述
1、在G2单元格输入公式:
=AVERAGEIF(C$2:C2,">0",F$2:F2)
下拉填充
如图:
2、在G2单元格输入公式:
=AVERAGEIFS(F$2:F2,C$2:C2,">0")