change 'count of' to 'sum of' in pivot table field
I'm transforming multiple excel sheets into a single sheet using pivot
tables. There are frequently multiple items in the data column which appear as 'count of'. Is there a simple way to get all the entries to be 'sum of' instead of doing each one manually?-we're talking about 100 items occasionally! Oh, and if you can answer this without using code, I'd appreciate it, Cheers now, Rob. |
change 'count of' to 'sum of' in pivot table field
If you have empty cells or cells with text in that field, excel "knows" you want
"count of". You can't change this behavior. You can use code to fix it, though. Debra Dalgleish has an addin that offers this plus a lot more stuff: http://www.contextures.com/xlPivotAddIn02.html and http://www.contextures.com/xlPivotAddIn.html Rob B wrote: I'm transforming multiple excel sheets into a single sheet using pivot tables. There are frequently multiple items in the data column which appear as 'count of'. Is there a simple way to get all the entries to be 'sum of' instead of doing each one manually?-we're talking about 100 items occasionally! Oh, and if you can answer this without using code, I'd appreciate it, Cheers now, Rob. -- Dave Peterson |
change 'count of' to 'sum of' in pivot table field
Hi Dave,
Thank you very much for that, I've asked the ICT guys for permission to dl it, but it looks like just the thing I've been looking for! |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com