ExcelBanter - Counting items in strings

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Counting items in strings (https://www.excelbanter.com/excel-programming/427178-counting-items-strings.html)

Slim Slender[_2_]

Counting items in strings

I have a table with a column that reads:
Br
Corr
SAP
SAP
Br, Gov
Comp
Br, SAP
Comp
Comp, Gov
Br
Br, SAP

I want to count the Br's and come up with 5 and not 2. I've tried a
PivotTable and I've tried Countif.
Any ideas.

Jacob Skaria

Counting items in strings

COUNTIF should work

=COUNTIF(A:A,"Br*")

If this post helps click Yes
---------------
Jacob Skaria

"Slim Slender" wrote:

I have a table with a column that reads:
Br
Corr
SAP
SAP
Br, Gov
Comp
Br, SAP
Comp
Comp, Gov
Br
Br, SAP

I want to count the Br's and come up with 5 and not 2. I've tried a
PivotTable and I've tried Countif.
Any ideas.

Slim Slender[_2_]

Counting items in strings

On Apr 19, 9:38*pm, Jacob Skaria
wrote:
COUNTIF should work

=COUNTIF(A:A,"Br*")

If this post helps click Yes
---------------
Jacob Skaria

I don't see Yes, but the formula worked. Thanks much.

All times are GMT +1. The time now is 05:35 PM.