=COUNTIF(A1:A10,"=*Br*")

--
Regards,

OssieMac


"Slim Slender" wrote:

I have a table with a column that has data like this:
Gov
Br
SAP
Br, SAP
Comp
Br, Gov
Br, SAP
Comp
Br,
SAP

Is there a formula I can put in a cell at the bottom that will count
the occurences of "Br" and return 5 rather than 2? Thanks in advance.