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

Re: Anyone good with pivot tables in Excel?
 

Re: Anyone good with pivot tables in Excel?
 

Can you send me the spreadsheet?

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

Re: Anyone good with pivot tables in Excel?
 

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

Re: Anyone good with pivot tables in Excel?
 

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.

Re: Anyone good with pivot tables in Excel?
 

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

Re: Anyone good with pivot tables in Excel?
 

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

Re: Anyone good with pivot tables in Excel?
 

Glad you figured it out :tu