ExcelBanter - pivottable: Why do I get Count instead of Sum when numeric data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pivottable: Why do I get Count instead of Sum when numeric data (https://www.excelbanter.com/excel-discussion-misc-queries/97571-pivottable-why-do-i-get-count-instead-sum-when-numeric-data.html)

Søren Søndergaard

pivottable: Why do I get Count instead of Sum when numeric data

If my source date is numeric I expect to get a Sum for a column. Often I get
Count instead of. How can I change med source data?

Ron Coderre

pivottable: Why do I get Count instead of Sum when numeric data

I believe that typically happens if the amounts column contains blanks.
If you double-click the field in Layout, you can change the function to SUM.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"Søren Søndergaard" wrote:

If my source date is numeric I expect to get a Sum for a column. Often I get
Count instead of. How can I change med source data?

All times are GMT +1. The time now is 02:19 PM.