Create AutoSubtotal button which functions like the AutoSum butto.

B

Bradley

Why have AutoSum and not AutoSubtotal? I write '=subtotal(9, ' a hundred
times a day. It is way more useful than just SUM.
 
F

Frank Kabel

Hi
you could always record/create a macro and assign a shortcut/icon for
this macro
 
D

Debra Dalgleish

If your list is filtered, and you click the AutoSum button, a SUBTOTAL
formula should be inserted, instead of a SUM formula.
 
Top