SUBTOTAL in Excel - Upgrade Your Calculations

[@Freemarkets1236]

Nice. All these years and I wasn’t aware of this. Granted I use pivot tables 99% of the time.

[@sheetskunk]

Nothing wrong with that! It’s nice having options 😀

[@deepu03393]

Is it possible to subtotal index numbers make it dynamic

[@sheetskunk]

Absolutely! If you're referring to the function selection, one way to do it would be to set up a drop-down list. So, if your drop-down selection is "Average", the corresponding cell would produce the number 1. When you create your SUBTOTAL formula, instead of inputting a static number, simply reference the cell that is dependent on the drop-down. If you meant making the actual range dynamic, you can do that as well. However, it depends on the situation. You could set up a table if you're just talking about including new rows to the data. Or if it's separate column indexes, you could do something similar to the example of using a drop-down. But instead of selecting a different function, you could select a different table column to subtotal. It all depends on what you're trying to do. But it is possible.