Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2014, 02:53 AM
MSA5455 MSA5455 is offline formulas Windows XP formulas Office 2013
Novice
formulas
 
Join Date: Dec 2014
Posts: 4
MSA5455 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 12-17-2014, 10:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline formulas Windows 7 64bit formulas Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 12-18-2014, 03:28 PM
MSA5455 MSA5455 is offline formulas Windows XP formulas Office 2013
Novice
formulas
 
Join Date: Dec 2014
Posts: 4
MSA5455 is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 12-19-2014, 01:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline formulas Windows 7 64bit formulas Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

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 Formulas in a different language poobear Excel 2 09-18-2011 04:35 AM
formulas IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft