ExcelBanter - Count Text In Column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count Text In Column (https://www.excelbanter.com/excel-discussion-misc-queries/176416-count-text-column.html)

Jeremy

Count Text In Column

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.

Kevin B

Count Text In Column

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

=COUNTIF(A1:A16,"=ZB")
--
Kevin Backmann

"Jeremy" wrote:

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.

Teethless mama

Count Text In Column

Try like this:

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

"Jeremy" wrote:

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.

All times are GMT +1. The time now is 06:35 AM.