Thread: pivottable: Why do I get Count instead of Sum when numeric data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default 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?


Reply With QuoteReply With Quote