Anyone good with pivot tables in Excel?

forgop · 05-26-2009, 06:45 PM

I've got a spreadsheet I'm trying to convert to a pivot table. The data I have is for a number of repetitive items that combines them into a single line item. The pivot table I've created summarizes that line of data but counts the number of instances it appears rather than the sum of all numbers in that field.

Anyone have any advice to show that with a sum feature?

Thanks!!!

WildBlueSooner · 05-26-2009, 06:48 PM

Quote:

Originally Posted by forgop

I've got a spreadsheet I'm trying to convert to a pivot table. The data I have is for a number of repetitive items that combines them into a single line item. The pivot table I've created summarizes that line of data but counts the number of instances it appears rather than the sum of all numbers in that field.

Anyone have any advice to show that with a sum feature?

Thanks!!!

HK3- · 05-26-2009, 07:30 PM

Can you send me the spreadsheet?

rennD · 05-26-2009, 07:48 PM

Don't have any experience but this is what I have found on Google:

http://www.microsoft.com/dynamics/us...s_collins.mspx

http://www.ozgrid.com/Excel/excel-pivot-tables.htm

http://www.timeatlas.com/mos/5_Minut...Organize_Data/

http://www.babeled.com/2008/07/18/ex...-manipulation/

http://www.lacher.com/toc/tutpiv.htm

dunng · 05-26-2009, 07:49 PM

So it's set to COUNT... just change it to SUM...

forgop · 05-26-2009, 07:51 PM

Quote:

Originally Posted by dunng

So it's set to COUNT... just change it to SUM...

I had that part figured out-I just don't know where to change it for the sum function.

I know, it's probably very simple, but this is my first time messing around with them.

dunng · 05-26-2009, 07:54 PM

In Office 2007, you would right click on the header and select Summarize Data by -> SUM.

forgop · 05-26-2009, 07:58 PM

Quote:

Originally Posted by rennD

Don't have any experience but this is what I have found on Google:

http://www.microsoft.com/dynamics/us...s_collins.mspx

I think this one may have helped me figure it out. I searched a bit, but never saw anything show me exactly where I can select "sum" instead of "count".

Thanks!!!

rennD · 05-26-2009, 08:00 PM

Glad you figured it out

05-26-2009, 06:45 PM	#1
forgop Not a puffer Join Date: Oct 2008 First Name: Duane Location: Indianapolis, IN Posts: 2,870 Trading: (40)	Anyone good with pivot tables in Excel? I've got a spreadsheet I'm trying to convert to a pivot table. The data I have is for a number of repetitive items that combines them into a single line item. The pivot table I've created summarizes that line of data but counts the number of instances it appears rather than the sum of all numbers in that field. Anyone have any advice to show that with a sum feature? Thanks!!!

05-26-2009, 07:30 PM	#3
HK3- Cashmere Jungle Lord Join Date: Oct 2008 First Name: Boffa Location: The town so nice they named it twice Posts: 5,035 Trading: (48)	Re: Anyone good with pivot tables in Excel? Can you send me the spreadsheet?

05-26-2009, 07:48 PM	#4
rennD NinfaManiac Join Date: Mar 2009 First Name: Carl Location: In a Cloud of Siglo Smoke Posts: 1,452 Trading: (19)	Re: Anyone good with pivot tables in Excel? Don't have any experience but this is what I have found on Google: http://www.microsoft.com/dynamics/us...s_collins.mspx http://www.ozgrid.com/Excel/excel-pivot-tables.htm http://www.timeatlas.com/mos/5_Minut...Organize_Data/ http://www.babeled.com/2008/07/18/ex...-manipulation/ http://www.lacher.com/toc/tutpiv.htm __________________ *Any cigars portrayed in this post that appear to be Cuban in origin are completely fictional in nature. Any resemblance between these cigars and actual Cuban cigars is unintended and coincidental.*

05-26-2009, 07:49 PM	#5
dunng MassHole Join Date: Oct 2008 First Name: Greg Location: MassHole Posts: 4,719 Trading: (59)	Re: Anyone good with pivot tables in Excel? So it's set to COUNT... just change it to SUM... __________________ MassHole Banter

05-26-2009, 07:54 PM	#7
dunng MassHole Join Date: Oct 2008 First Name: Greg Location: MassHole Posts: 4,719 Trading: (59)	Re: Anyone good with pivot tables in Excel? In Office 2007, you would right click on the header and select Summarize Data by -> SUM. __________________ MassHole Banter

05-26-2009, 08:00 PM	#9
rennD NinfaManiac Join Date: Mar 2009 First Name: Carl Location: In a Cloud of Siglo Smoke Posts: 1,452 Trading: (19)	Re: Anyone good with pivot tables in Excel? Glad you figured it out __________________ *Any cigars portrayed in this post that appear to be Cuban in origin are completely fictional in nature. Any resemblance between these cigars and actual Cuban cigars is unintended and coincidental.*