Counting conditionally

[Slim Slender]

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.

 

[OssieMac]

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

 

[Mike H]

Try this

=SUMPRODUCT((LEFT(A1:A10,2)="Br")*(1))

Mike

 

[Stefi]

=SUMPRODUCT(--ISERROR(SEARCH("br",A1:A10)))

Regards,
Stefi

„Slim Slender†ezt írta:

 

[Stefi]

Sorry, this is the right one:
=SUMPRODUCT(--NOT(ISERROR(SEARCH("br",A1:A10))))
stefi


„Slim Slender†ezt írta:

 

[Bernd P]

Or
=SUMPRODUCT(1-ISERROR(SEARCH("br",A1:A10)))

Regards,
Bernd

 

[Slim Slender]

Or
=SUMPRODUCT(1-ISERROR(SEARCH("br",A1:A10)))

Regards,
Bernd

Thanks to everyone for answers. Problem solved!