| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Q: Change pivot table source path? | Excel Discussion (Misc queries) | |||
| How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
| Pivot Table Comment Field | Excel Discussion (Misc queries) | |||
| Count in Pivot Table | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
