You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.

There's a feature that changes all the data fields to SUM, in my pivot
table add-in, that you can download he

http://www.contextures.com/xlPivotAddIn.html


stevehere wrote:
Hi,
when dragging in data fields into a pivot table, the default field type
most often comes up as 'count'. I often have to right click over the
field, and change the field setting to sum, and do this individually
for each field. Does someone know if there is a way to change the
default to 'sum' or to quickly convert all the data fields to sum in my
pivot table? This is annoying the hell out of me!
Much appreciated,
Steve.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html