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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I make AutoSum really Sum, not Subtotal 5
need help creating "AutoSubtotal" toolbar button 3
Autogroup then sum - can it be done? 5
Setting language of a selected text in Office apps. 0
why are my worksheet autosum totals one cent off? 2
Excel 2007 - sum function not working 2
autosum 1
textbox autosum 5

Top