单项选择题
现有学生基本情况表,其中C2:C13表示性别,G2:G13表示奖学金,若要求表中男同学的奖学金平均值,可在指定单元格中输入公式( )
A.
=AVERAGEIF(C2:C13,"男",G2:G13) B.
=AVERAGEIF(G2:G13,"男", C2:C13) C.
=AVERAGEIFS(C2:C13,"男",G2:G13) D.
=AVERAGEIFS(G2:G13,"男",C2:C13)
现有学生基本情况表,其中C2:C13表示性别,G2:G13表示奖学金,若要求表中男同学的奖学金平均值,可在指定单元格中输入公式( )
A.
=AVERAGEIF(C2:C13,"男",G2:G13) B.
=AVERAGEIF(G2:G13,"男", C2:C13) C.
=AVERAGEIFS(C2:C13,"男",G2:G13) D.
=AVERAGEIFS(G2:G13,"男",C2:C13)