Using the Subtotal Function

An Excel file that teaches how to perform Using the Subtotal Function operation.

Excel Format: Using the Subtotal Function

The Subtotal function considers active rows in filtered data. The function number changes depending on the operation type. Hidden rows are excluded from the calculation. Report fields are dynamically updated. The result is transferred to the summary table.

Hope it is useful.