COUNTIF function
Summary
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(Where do you want to look?, What do you want to look for?)
Example
=COUNTIF(A2:A5,"apples")
=COUNTIF(A2:A5,A4)
=COUNTIF(A2:A5,A2)+COUNTIF(A2:A5,A3)
=COUNTIF(B2:B5,">55")
=COUNTIF(B2:B5,"<>"&B4)
=COUNTIF(B2:B5,">=32")-COUNTIF(B2:B5,"<=85")
=COUNTIF(A2:A5,"*")
=COUNTIF(A2:A5,"?????es")
=COUNTIF(A2:A5,A4)
=COUNTIF(A2:A5,A2)+COUNTIF(A2:A5,A3)
=COUNTIF(B2:B5,">55")
=COUNTIF(B2:B5,"<>"&B4)
=COUNTIF(B2:B5,">=32")-COUNTIF(B2:B5,"<=85")
=COUNTIF(A2:A5,"*")
=COUNTIF(A2:A5,"?????es")