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

Hi,

Sample workbook would be helpful.
Avatar of skullnobrains
skullnobrains

hmm ... why pivot ?

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

Link to home
membership
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

ASKER

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.