Link to home
Create AccountLog in
Avatar of Lyndall Bradley
Lyndall Bradley

asked on

How to count the number of customers ordering at an item - pivot table

Column A: - Unique identification number of product
Column B: Departments ordering

I would like to count the number of  departments ordering  a unique product in Colum A
Avatar of Shums Faruk
Shums Faruk
Flag of India image


Sample workbook would be helpful.
Avatar of skullnobrains

hmm ... why pivot ?

select A,count(B) from table group by A
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
oups : missed the excel part ;) sorry
if you need a formula for a specific product, something like this should do : count(if(A1:A100 = "myproduct",B1:B100))
Avatar of Lyndall Bradley


Thank-you for your replies.

The attached workbook. I would like to know how many times the customers in Colum B orders column A. Thank-you for your time and assistance.
you'd need to replace the "sum" by a "count" in the calculated data ( or add an extra column ).
click on the pivot and find where you can add a new "value" or "set of values" which will actually ask for the type of value ( sum, count, count unique ... ) and add the corresponding extra column.