Count Number of products

[willyinaus]

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

 

[dmadeka]

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.