Question

what is subtotal explain with example?
​

Answer 1

Answer:

The Excel SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others (see table below), and SUBTOTAL function can either include or exclude values in hidden rows. Get a subtotal in a list or database. A number representing a specific kind of subtotal.

ex.

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.