Question

excel COUNTIFS 函数怎样统计满足a或b

比如A列有a，b,c,d 不同字母。怎样统计a或b 的个数
就是统计a和b的总数

Answer 1

=SUM(COUNTIF(A:A,{"a","b"}))
或
=COUNTIF(A:A,"a")+COUNTIF(A:A,"b")
这两个公式不区分字母大小写
=SUMPRODUCT(LEN(A1:A9)-LEN(SUBSTITUTE(SUBSTITUTE(A1:A9,"a",),"b",)))

Answer 2

=SUM(COUNTIF(A:A,{"a","b"}))
或
=COUNTIF(A:A,"a")+COUNTIF(A:A,"b")
这两个公式不区分字母大小写
=SUMPRODUCT(LEN(A1:A9)-LEN(SUBSTITUTE(SUBSTITUTE(A1:A9,"a",),"b",)))

Answer 3

=SUM(COUNTIFS(A:A,{"a","b"}))

Answer 4

=countif(A:A,"A")+countif(A:A,"B")

Answer 5

引用allenfar的回答：
a或b?
a且b吧

a或b?
a且b吧