关于EXCEL中公式AVERAGEIFS难题

发布网友发布时间：2022-05-23 11:17

共4个回答

热心网友时间：2023-09-18 00:50

两个班的总分。=SUM(SUMIF($A3:$A901,{"02","09"},D3:D901))/SUM(COUNTIF($A3:$A901,{"02","09"}))
60分及格，及格率=(SUMPRODUCT((D3:D901>=60)*($A3:$A901="02")))/COUNTIF$A3:$A901,"02")
90分优秀，优秀率=SUMPRODUCT((D3:D901>=90)*($A3:$A901="02")))/COUNTIF$A3:$A901,"02")

热心网友时间：2023-09-18 00:51

我是03版的没这个公式啊，是两个班一起的平均值吗？用（2班的平均值*2班人数+9班的平均值*9班人数）/（2班人数+9班人数）(AVERAGEIFS(D3:D901,$A3:$A901,"=02")*count($A3:$A901,"=02")+AVERAGEIFS(D3:D901,$A3:$A901,"=09")*count($A3:$A901,"=09"))/(count($A3:$A901,"=02")+count($A3:$A901,"=09"))

热心网友时间：2023-09-18 00:51

=SUM(SUMIF($A3:$A901,{"02","09"},D3:D901))/SUM(COUNTIF($A3:$A901,{"02","09"}))

热心网友时间：2023-09-18 00:52

=SUMPRODUCT((D3:D901={"02","09"})*A3:A901)/SUMPRODUCT(N(D3:D901={"02","09"}))