Can I change subtotal default settings from count to sum, for exam
 

I'd like to change the defaults of the subtotal menu - I use the same choices
everytime.

Can I change subtotal default settings from count to sum, for exam
 

I don't think you can change that behavior.


sshelton wrote:

I'd like to change the defaults of the subtotal menu - I use the same choices
everytime.

--

Dave Peterson

Can I change subtotal default settings from count to sum, for exam
 

Depends upon what type of data is in the range.

If numerics it will default to Sum, if not, defaults to Count


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 08:57:01 -0700, sshelton
wrote:

I'd like to change the defaults of the subtotal menu - I use the same choices
everytime.