ExcelBanter - Create AutoSubtotal button which functions like the AutoSum butto.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Create AutoSubtotal button which functions like the AutoSum butto. (https://www.excelbanter.com/excel-worksheet-functions/7263-create-autosubtotal-button-functions-like-autosum-butto.html)

Bradley

Create AutoSubtotal button which functions like the AutoSum butto.

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

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

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

Debra Dalgleish

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

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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 05:32 PM.