Default pivot table function

M

Mike Boardman

Is there any way of having the default pivot table function come up as SUM
rather than COUNT?

I use them a lot, and it gets annoying to have to change it 99% of the time!

TIA
 
M

Mike Boardman

Frank

Thanks for that - I had a horrible feeling it might not be the case! It does
rather beg the question "Why is SUM the first function listed but Count is
the default?!!!"

Ahj well, not to worry - life's too short to ponder the mysteries of
Microsoft's ways!

Mike
 
D

Debra Dalgleish

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.
 
M

Mike Boardman

Debra

Thanks a lot -that explains it! We often have blank cells in the data, so
we'll have to see if we can eliminate them.

Mike
 
K

Ken Wright

As long as you can live with what was blank being 0, then select the entire
table, do Edit / Go To / Special / Blanks, type 0 then CTRL+ENTER and it will
populate all blanks with 0. Your data will now all default to SUM.
 
Top