excel COUNTIF 函数多条件查询引用单元格

weixin_46670668

已于 2023-08-03 11:22:14 修改

阅读量1.7k

点赞数

文章标签： excel

于 2023-08-02 11:29:37 首次发布

本文链接：https://blog.csdn.net/weixin_46670668/article/details/132058515

版权

=SUMPRODUCT(N(总成绩!G1:G1137>=5000))
多条件计数
=COUNTIF(总成绩!G1:G3000,">537")
=COUNTIF(总成绩!C1:C3000,"=17班")

=COUNTIFS(总成绩!G1:G3000,">=537",总成绩!C1:C3000,"=17班")
=COUNTIFS(总成绩!K1:K3000,">=110",总成绩!C1:C3000,"=17班")

=COUNTIFS(总成绩!G1:G3000,">=537",总成绩!C1:C3000,"=17班",总成绩!K1:K3000,">=110",总成绩!C1:C3000,"=17班")

=COUNTIFS(总成绩!G1:G3000,">=537",总成绩!C1:C3000,"="&A7)

=CONCAT(RIGHT(A7,2),"班")

=COUNTIFS(总成绩!G1:G3000,">=537",总成绩!C1:C3000,"="&CONCAT(RIGHT(A7,2),"班"))
=COUNTIFS(总成绩!K1:K3000,">=110",总成绩!C1:C3000,"="&CONCAT(RIGHT(A7,2),"班"))
=COUNTIFS(总成绩!$G$1:$G$3000,">=537",总成绩!$L$1:$L$3000,">=110",总成绩!$C$1:$C$3000,"="&CONCAT(RIGHT(A7,2),"班"))