Programming Hotkey for open ended formula

Hello,

I'm summing filtered data and in order to do this I am using the formula =SUBTOTAL(9,"range of data"). I'm doing this repeatedly and each time typing in "subt" then hitting tab to autofill, then hitting "9," then selecting my range of cells in my filtered data that I want totaled then hitting enter.

What I would like to be able to do is program a hotkey that automatically gives me the following when pressed: [=SUBTOTAL(9,] so that I can hit the hotkey then select my data and hit enter versus having to repeatedly type out "subt" and hit tab, then "9" then "," before I select my data range.

I tried recording a macro, but it wouldn't let me do that with the open ended "=SUBTOTAL(9," formula I was typing.

Thank you for the help.

Welcome to the forum.

The best I can suggest is to use Autocorrect.
This won't give you a single-key entry, but should be quicker than what you're doing at the moment.
Make a new entry with this in the 'Replace:' box: =s
and this in the 'With:' box: =SUBTOTAL(9
Once you've OK'd out, if you type =s then comma, Excel should change that to =SUBTOTAL(9, after which you can select your range, type the final bracket then Enter.

Don't try to include the comma in the 'With:' box, as it's that which makes Excel apply the Autocorrect.

Hope that helps.

You're welcome, glad I could help - even if it wasn't quite the solution you hoped for.
However, if you're satisfied that your question has been answered, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.