Cigar Asylum Cigar Forum - View Single Post

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

05-26-2009, 06:45 PM	#1
forgop Not a puffer Join Date: Oct 2008 First Name: Duane Location: Indianapolis, IN Posts: 2,869 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!!!