On Tue, 7 Aug 2012 09:09:17 +0000, blivy wrote:

Hi,

I'm trying to count the number of entries in a range B2:B1847 that are
either
BKROCK
BLACKRCK
BLACKROCK
BLACROCK
BLK RCK
BLKRCK
BLKRK
BLKRO
BLKROCK
(note that these all have numerous strings of differing amounts of
numbers on the end so I cannot use a RIGHT function)

I assume these strings are only a portion of the cells contents.

If you have a list of the desired substrings in some range, e.g: K1:K9, you can try this formula for a case INsensitive match:

=SUMPRODUCT(COUNTIF($B$2:$B$1847,"*"&$K$1:$K$9&"*" ))