Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables: SUM not COUNT!!!!!!!!
Whenever I create a pivot table, Excel has a nasty habit of always (wrongly) assuming function COUNT to apply to any data placed in the pivot table, even if the data is purely numeric. How do I permanently fix Excel's cretinous obsession with counting and replace it with the required function? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables: SUM not COUNT!!!!!!!!
Hi Martin
You cannot "fix" Excel's method used with Data. The default for Numeric data is SUM, and the default for text data is COUNT. I suspect that your range of numeric data, also includes blank cells, which would cause Excel to switch from using Sum to Count. If there are not blank cells within your data range, but there are blank cells below the used range, then try using a dynamic range for your data, to limit the range to that containing numeric data. Otherwise, I'm afraid you will have to change the selection each time, as you do at present. -- Regards Roger Govier "Martin James Thornhill" wrote in message ... Whenever I create a pivot table, Excel has a nasty habit of always (wrongly) assuming function COUNT to apply to any data placed in the pivot table, even if the data is purely numeric. How do I permanently fix Excel's cretinous obsession with counting and replace it with the required function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
How do I keep file sizes small when using multiple pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |