Count Text In Column

[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.

 

[Kevin B]

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

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

 

[Teethless mama]

Try like this:

=COUNTIF(H2:H300,"zb")
or
=SUMPRODUCT(--(H2:H300="zb"))