formulas
I am stuck doing a formula in excel 2013. Column A is products i.e product 1, product 2, product 3 ect, and Column B is quantities. I want a summary on a separate sheet to show the total quantities of each product. I don't know what formula to use can anyone help please?
Eg
Column A Column B
product 1 30.00
product 2 25.00
Product 1 10.00
Product 3 15.00
Summary quantities
Product 1 formula total quantities of product 1
Product 2
Product 3
|