Anyone good with pivot tables in Excel?

[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!!!

[WildBlueSooner]

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!!!

http://bizzoony.files.wordpress.com/2006/12/what-choo-talkin-bout-willis.jpg

[HK3-]

Can you send me the spreadsheet?

[rennD]

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

http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx

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

http://www.timeatlas.com/mos/5_Minute_Tips/Chunkers/Learn_to_use_Pivot_Tables_in_Excel_2007_to_Organiz e_Data/

http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/

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

[dunng]

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

[forgop]

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]

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

[forgop]

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

http://www.microsoft.com/dynamics/using/excel_pivot_tables_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]

Glad you figured it out :tu