Excel::COUNTIF()

A B
1 Data Data
2 apples 32
3 oranges 54
4 peaches 75
5 apples 86


=COUNTIF(A2:A5,"apples") Number of cells with apples in the first column above (2)
=COUNTIF(A2:A5,A4) Number of cells with peaches in the first column above (1)
=COUNTIF(A2:A5,A3)+COUNTIF(A2:A5,A2) Number of cells with oranges or apples in the first column above (3)
=COUNTIF(B2:B5,">55") Number of cells with a value greater than 55 in the second column above (2)
=COUNTIF(B2:B5,"<>"&B4) Number of cells with a value not equal to 75 in the second column above (2)
=COUNTIF(B2:B5,">=32")-COUNTIF(B2:B5,">85") Number of cells with a value greater than or equal to 32 and less than or equal to 85 in the second column above (3)




=COUNTIF(A2:A7,"*es") Number of cells ending with the letters "es" in the first column above (4)
=COUNTIF(A2:A7,"?????es") Number of cells ending with the letters "les" and having exactly 7 letters in the first column above (2)
=COUNTIF(A2:A7,"*") Number of cells containing text in the first column above (4)
=COUNTIF(A2:A7,"<>"&"*") Number of cells not containing text in the first column above (2)
=COUNTIF(B2:B7,"No") / ROWS(B2:B7) The average number of No votes including blank cells in the second column above formatted as a percentage with no decimal places (33%)
=COUNTIF(B2:B7,"Yes") / (ROWS(B2:B7) -COUNTIF(B2:B7, "<>"&"*")) The average number of Yes votes excluding blank cells in the second column above formatted as a percentage with no decimal places (50%)