郭晓仪 发表于 2021-12-9 21:20:00

求助有条件要求的平均值

如附件，怎么求该条件下C列的平均值呢？

我本清闲 发表于 2022-1-3 14:46:22

=AVERAGEIFS(C:C,B:B,">=1",B:B,"<=999")

無丶衹境 发表于 2022-2-21 12:28:18

=AVERAGE(IF(($B$2:$B$9999>=1)*($B$2:$B$9999<=999),$C$2:$C$9999))数组公式

董毅云 发表于 2022-3-6 07:00:12

=AVERAGEIFS($C$2:$C$1001,$B$2:$B$1001,">=1",$B$2:$B$1001,"<=999")
页: [1]
查看完整版本: 求助有条件要求的平均值