COUNTIF
=COUNTIF(A2:A5,“London”)
统计 A2到A5 区域内的值等于“London” 的个数
=COUNTIF(A2:A5,A4)
统计 A2到A5 区域内的值等于A4的值的个数
=COUNTIF(A2:A5,A2)+COUNTIF(A2:A5,A3)
将两个 统计 结果相加
=COUNTIF(B2:B5,">55")
Counts the number of cells with a value greater than 55 in cells B2 through B5.
统计 B2 到 B5 单元格中值大于 55 的个数
=COUNTIF(A2:A5,"*PDF*")
Counts the number of cells containing any text in cells A2 through A5. The asterisk (*) is used as the wildcard character to match any character
统计 A2 到 A5区域单元格的值包含“PDF”的个数; * 当作是通配符,匹配任意字符