追加高分悬赏！EXCEL 专家请进！急！！！有关数据筛选（if函数）解决方案。

单价在3000元以上时，费用栏中0-199元的价格段有几个=COUNTIFS(B:B,">如圆衡=3000",A:A,">=0",A:A,"<=199")
200-399元的价格段有几个=COUNTIFS(B:B,">=3000",A:A,">=200",A:A,"<=399")
400-799元价格段有几个=COUNTIFS(B:B,">=3000",A:A,">=400",A:A,"<=799")
800-999元的价格段有几个=COUNTIFS(B:B,">=3000",A:A,">=800",A:A,"<=999")
1000元以上的价格段腔租有几个=COUNTIFS(B:B,">=3000",A:A,">=1000")
其他类同

把附件发474054817@qq.com，帮你整渣做理一下吧。

用公式：
1）0-199
=SUMPRODUCT((A2:A35<200)*(B2:B35>=3000))
200-399
=SUMPRODUCT((A2:A35>=200)*(A2:A35<400)*(B2:B35>=3000))
400-799
=SUMPRODUCT((A2:A35>=400)*(A2:A35<800)*(B2:B35>=3000))
800-999
=SUMPRODUCT((A2:A35>=800)*(A2:A35<戚汪1000)*(B2:B35>=3000))
1000以上
=SUMPRODUCT((A2:A35>=1000)*(B2:B35>=3000))

2）
0-199
=SUMPRODUCT((A2:A35<200)*(B2:B35>=2000)*(B2:B35<3000))
200-399
=SUMPRODUCT((A2:A35>=200)*(A2:A35<400)*(B2:B35>=2000)*(B2:B35<3000))
400-799
=SUMPRODUCT((A2:A35>=400)*(A2:A35<800)*(B2:B35>=2000)*(B2:B35<3000))
800-999
=SUMPRODUCT((A2:A35>=800)*(A2:A35<1000)*(B2:B35>=2000)*(B2:B35<3000))
1000以上渣悉
=SUMPRODUCT((A2:A35>=1000)*(B2:B35>=2000)*(B2:B35<3000))
3)根据上面公式作相应如仔乎修改就行了。

=SUMPRODUCT((单价区域>3000)*(费族物用区域兆和液>0)*(费用区域<199))
其他以此类棚耐推
可以发样表
mrpinetree@qq.com