Pivot Table default (Sum or Count)

[rvences]

My pivot tables ssem to have a mind of their own when it comes to summarizing numbers. Occasionally my pivots will sum my numerical data by default. On other occasions it will count my numerical data by default. It's very annoying to manually adjust all my fields from "count" to "sum" formulas. Is there a setting that allows me to choose "sum" as my default selection for summarizing data? Please help!!

Thanks

 

[Mudface]

Sum is the default if your chosen field contains nothing but numbers. If *any* of the data isn't a number, even if it's a blank cell, then the default will come up as Count.

 

[Chris Davison]

so this is why mine default to "count" also.... I usually refer to the whole column in the pivot cos the data ranges continually expand each month. Nice one Mudface, you solved a problem I didn't even realise I had

 

[rvences]

Thanks for the info.!!