countif

=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")

 

 

Formula	Description (result)
=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%)