View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default Excel pivot table field settings

Usually the default setting is SUM for numbers and COUNT for text. You may
need to check that you don't have text formatted information in the columns
that you use for the data.

Hope this helps,
Miguel.

"kyfriedchipper" wrote:

How can I change the default settings in the field settings? I want it to SUM
instead of COUNT. I am having to change multiple fields one at a time.
Thanks.