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.