Create AutoSubtotal button which functions like the AutoSum butto.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why have AutoSum and not AutoSubtotal? I write '=subtotal(9, ' a hundred
times a day. It is way more useful than just SUM.
 
Hi
you could always record/create a macro and assign a shortcut/icon for
this macro
 
If your list is filtered, and you click the AutoSum button, a SUBTOTAL
formula should be inserted, instead of a SUM formula.
 
You must log in or register to reply here.

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
autosum problems 1
Autogroup then sum - can it be done? 5
Excel 2007 - sum function not working 2
Autosum function 3
How can I set up a shortcut key for Autosum? 3
Why is it important to check the range placed in the SUM function. 2

Back
Top