T
Todd Vohs
I have a workbook with 2 spreadsheets. In the first one, I have a column of
products that has a corresponding customer and the customer may appear more
than once. I want to query that sheet and in the second sheet, have the
customer list with the sum of quantity of products that customer purchased.
All products are equivalent in size just different genetics. I just want to
know how many each customer purchased.
Sheet 1
customer1 product1 qty
customer2 product1 qty
customer2 product2 qty
customer2 product3 qty
customer3 product1 qty
customer3 product2 qty
customer4 product1 qty
customer4 product2 qty
Sheet 2
customer1 sum
customer2 sum
customer3 sum
cusomter4 sum
products that has a corresponding customer and the customer may appear more
than once. I want to query that sheet and in the second sheet, have the
customer list with the sum of quantity of products that customer purchased.
All products are equivalent in size just different genetics. I just want to
know how many each customer purchased.
Sheet 1
customer1 product1 qty
customer2 product1 qty
customer2 product2 qty
customer2 product3 qty
customer3 product1 qty
customer3 product2 qty
customer4 product1 qty
customer4 product2 qty
Sheet 2
customer1 sum
customer2 sum
customer3 sum
cusomter4 sum