excel中求有条件平均值

取B1到B9中,1000到1500范围内的平均值?
2025-05-12 18:41:54
推荐回答(1个)
回答1:

=AVERAGEIFS(B1:B9,B1:B9,">=1000",B1:B9,"<=1500")