![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
如图所示的“学生综合测评数据表” , 要分别统计女生和男生的综合成绩平均值 , 正确的公式是 ( ) 。
A.
= AVERAGEIFS(C2:C41,"女",D2:D41)和= AVERAGEIFS(C2:C41,"男”,D2:D41)
B.
= AVERAGEIF(C2:C41,D2:D41,"女")和=AVERAGEIF(C2:C41,D2:D41, "男")
C.
= AVERAGEIFS(D2 ;D41,"女”,C2:C41)和一AVERAGEIFS(D2:D41,"男”,C2:C41)
D.
=AVERAGEIF(C2:C41,"女”,D2:D41)和=AVERAGEIF(C2:C41,"男",D2:D41)