How about sample data and results Patrick?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Patrick_KC" wrote in message
...
I have a list of accounts with top 5 brands in each account. I'm trying
to
count the number of occurrences where my client has #1 brand, #2 brand,
etc.
But when I use countif function, I don't know how to list all of the
clients
brands as criteria. Any one of 9 brands could be in the rankings.

How do I use countif with 9 different "options" as criteria. I tried the
OR
function, but it didn't work unless I had errors in my formula.

Any help is appreciated.