无铭剑客 发表于 2021-12-22 11:59:00

求助筛选部分数据的球平均值

如图，求B列的平均值。要求范围在0





十分爱 发表于 2022-1-15 16:47:19

=SUMPRODUCT(((B$2:B$74>0)*(B$2:B$74<0.2)+(B$2:B$74>=0.2)*(B$2:B$74<=0.4)*(A$2:A$74>10))*B$2:B$74)/SUMPRODUCT(((B$2:B$74>0)*(B$2:B$74<0.2)+(B$2:B$74>=0.2)*(B$2:B$74<=0.4)*(A$2:A$74>10)))

崔松岩 发表于 2022-1-18 02:06:06

=(SUMIFS(B2:B74,B2:B74,"<0.2",B2:B74,">0")+SUMIFS(B2:B74,B2:B74,">=0.2",B2:B74,"<=0.4",A2:A74,">10"))/(SUMPRODUCT((B2:B74>0)*(B2:B74<0.2))+SUMPRODUCT((B2:B74>=0.2)*(B2:B74<=0.4)*(A2:A74>10)))
页: [1]
查看完整版本: 求助筛选部分数据的球平均值