Count Number of products

willyinaus

New Member
Joined
Aug 6, 2006
Messages
4
Not real sure how to do this.

What I have is a excel sheet with all the sales from my customers in an area say Sydney now I can filter those and export to excel no problem.

I could do this the way they have always done via pen and paper but I value my mental health and time and with over 5000 lines its going to take me forever.

What I need to do is count the number of products from the customer for a particular code and put that in a cell.

So in column A I have customer name as well as all the product codes and the sales quantity in column G.


Column A Column G
Jason Huma |Quantity
VD063 12
PT100 6
VF300 19

Sydney Mita |Quantity
VD063 12
PT100 6
VF300 19

What's the best way to do this?

Thanks willy
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

dmadeka

New Member
Joined
Jan 5, 2011
Messages
29
You haven't given any indication on how you source data looks.

However if its a list with
Customer | Product Code | Quantity

You could simply use a pivot table.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,444
Messages
5,642,187
Members
417,259
Latest member
gtacw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top