Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why does my Excel pivottable uses count instead of sum
When I create a pivottable from some imported data Excel (2003 SP2) sometimes
chooses to summarize the data by using the function "count" instead of "sum", which I then have change manually. What is it in the database that is triggering Excel to choose either function? |
#2
|
|||
|
|||
Why does my Excel pivottable uses count instead of sum
If a field contains blanks, or text, the Count function is used.
Otherwise, the Sum function is used. Marcus wrote: When I create a pivottable from some imported data Excel (2003 SP2) sometimes chooses to summarize the data by using the function "count" instead of "sum", which I then have change manually. What is it in the database that is triggering Excel to choose either function? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Why does my Excel pivottable uses count instead of sum
You can see which function Excel has chosen when creating the layout; look
at the name: SumOfValue or CountOfValue. If you need to change it, double-click on the entry ('CountOfValue') and choose a different function under 'SummarizeBy'. "Marcus Ahlbäck" wrote: When I create a pivottable from some imported data Excel (2003 SP2) sometimes chooses to summarize the data by using the function "count" instead of "sum", which I then have change manually. What is it in the database that is triggering Excel to choose either function? |
#4
|
|||
|
|||
Why does my Excel pivottable uses count instead of sum
Thanks for o quick reply
Seems like the Count function is used if the data field contains error-values as well. Not so bad really, as it offers a way to debugging and cleaning the database (if I get a count-function I can take that as a hint that I might have some cleaning to do). "Debra Dalgleish" wrote: If a field contains blanks, or text, the Count function is used. Otherwise, the Sum function is used. Marcus wrote: When I create a pivottable from some imported data Excel (2003 SP2) sometimes chooses to summarize the data by using the function "count" instead of "sum", which I then have change manually. What is it in the database that is triggering Excel to choose either function? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Count by color using VBA in Microsoft Excel | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
to How to use Excel formula to count the item | Excel Discussion (Misc queries) | |||
PivotTable - Count by Month | Excel Worksheet Functions |