Count Text In Column

J

Jeremy

I just need a formula to count how many times "ZB" appears in column H.

I've tried
=SUMPRODUCT(H1:H300="zb")
=COUNT("zb", H2:H300)
=COUNT(H2:H300, "zb")

This does not seem like a terribly difficult formula, but everything returns
0.
Thanks in advance.
 
K

Kevin B

Try the following formula, substituting your range for the range A1:A16:

=COUNTIF(A1:A16,"=ZB")
 
Top