Question

Where is the SUBTOTAL function located?

Answer 1

Answer:

Apply a filter to the list. In this example, the Region column is filtered for “West”.

In the row immediately below the list, select the cell where you want the grand total.

On Excel's Home tab, click the AutoSum button. OR, on the keyboard, press the Alt key and tap the equal sign key (Alt + =).