Countif w/ Multiple Criteria

Let's try something simple. Quickly add a column on the extreme right of your
data with 1 on all the rows. Now simply create a Pivot to get count of brands
- in the data - you can keep the sum of the column with 1 on all the rows.

Hope, this heps. If not, please be more clear in decribing how exactly yoour
worksheet(s) are laid out.

Thanks,

Manish Bajpai

"Patrick_KC" wrote:

> 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.
>
>

How about sample data and results Patrick?

--

HTH

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


"Patrick_KC" <PatrickKC@discussions.microsoft.com> wrote in message
news:413E033E-0F71-4456-B595-CF0FC3B391AB@microsoft.com...
> 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.
>
>

Let's try something simple. Quickly add a column on the extreme right of your
data with 1 on all the rows. Now simply create a Pivot to get count of brands
- in the data - you can keep the sum of the column with 1 on all the rows.

Hope, this heps. If not, please be more clear in decribing how exactly yoour
worksheet(s) are laid out.

Thanks,

Manish Bajpai

"Patrick_KC" wrote:

> 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.
>
>

How about sample data and results Patrick?

--

HTH

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


"Patrick_KC" <PatrickKC@discussions.microsoft.com> wrote in message
news:413E033E-0F71-4456-B595-CF0FC3B391AB@microsoft.com...
> 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.
>
>

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.

Let's try something simple. Quickly add a column on the extreme right of your
data with 1 on all the rows. Now simply create a Pivot to get count of brands
- in the data - you can keep the sum of the column with 1 on all the rows.

Hope, this heps. If not, please be more clear in decribing how exactly yoour
worksheet(s) are laid out.

Thanks,

Manish Bajpai

"Patrick_KC" wrote:

> 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.
>
>

How about sample data and results Patrick?

--

HTH

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


"Patrick_KC" <PatrickKC@discussions.microsoft.com> wrote in message
news:413E033E-0F71-4456-B595-CF0FC3B391AB@microsoft.com...
> 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.
>
>