| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set the default "summarized by" of a data field to "Sum"?
When making pivot table, it's very common that when a data field is dragged
into the table, it is defaulted to be summarized by Count, while in most cases, it's a Sum that we need. Is that a way to set "Sum" as a default? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to set the default "summarized by" of a data field to "Sum"?
Nope.
Excel will use sum if all the entries in that field are numeric. If any are blank or text, you'll get Count. Jeffrey wrote: When making pivot table, it's very common that when a data field is dragged into the table, it is defaulted to be summarized by Count, while in most cases, it's a Sum that we need. Is that a way to set "Sum" as a default? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Copy Data from on field to another? Complex? | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Pivot table - Text in Data field | Excel Discussion (Misc queries) | |||
Linear Mode
