Count if Help

[resulgul]

Hi Guys,

I have searched for a solution but have not been able to find one in the old threads.
My problem is that I want to count how many times a product accours in each channel.
For example the product accurs 5 times in the corporate reseller channel and 15 times in the mail order channel.
Is there a way of doing this?
I have tried the countif formula but I couldnt get around it.

Any help is appriciated.

[BigBas]

Why not add countifs?

=COUNTIF(A2:A35,"MAIL ORDER")+COUNTIF(A2:A35,"CORPORATE RESELLER")

Does this help?

[resulgul]

Thanks for the reply but this doesnt help.
You see, what i am tring to do is count the accurances in each channel.
Basically i'm trying to do the job of a pivot table without using pivots.

Hope this is clear.

Thanks

Resul

[Ron Coderre]

Here's one way:

=SUM(COUNTIF(A1:A34,{"Corporate Reseller","Mail Order"}))

Does that help?

[resulgul]

no guys, I dont I'm clear.
I want to find the number of each accurance in each channel.
Bear in mind that I have thounds of channels and products.

A way i can get around it is if I contatenate cells A and B and the do the formula 'COUNTIF(D2:D34,D2)'.
But is there a way of doig this without mixing the data?

[Ron Coderre]

Thanks for the reply but this doesnt help.
You see, what i am tring to do is count the accurances in each channel.
Basically i'm trying to do the job of a pivot table without using pivots.

Hope this is clear.

Thanks

Resul

Hi, Resul....

Are you hoping to automatically list each unique Channel and display the corresponding count?

Please Login or Register  to view this content.

[resulgul]

Yep, thats exactly what I'm trying to do

[Ron Coderre]

Yep, thats exactly what I'm trying to do

OK....Here you go:

Please Login or Register  to view this content.

Is that something you can work with?

[resulgul]

i have tried this as well but it doesnt do what i want it to do.
I guess I will just concatenate and then use the countif formula.

Thanks for all your help and ideas guys.