#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Hi
the easiest and fastest way is to use a Pivot Table. You will need headers in each column.Select a cell somewhere in the range then Insert - Pivot Table. Drag the product to comun range and the quantities to totals. If you need to do something else with the result, you can use the SUMIF function
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Hi Pecoflyer
Thank you for your reply, it is much appreciated. I have used the sumif function, which I have never used before. This gives me the result I need. I am struggling a bit with pivot tables as I have never used them before. I need to spend some time reading up on this and trying to work it out. I am sure this will be a lot easier once I know how to use it. Thanks again. Have a good christmas |
#4
|
||||
|
||||
You're welcome.
Here is a good place to start http://www.contextures.com/CreatePivotTable.html Merry Christmas to you too
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with IF or ELSE Formulas | tsaladyga | Excel | 4 | 07-23-2014 09:04 AM |
Excel Formulas | barryjones | Excel | 2 | 06-03-2013 04:27 AM |
Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
Formulas in a different language | poobear | Excel | 2 | 09-18-2011 04:35 AM |
IF Formulas | mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |