The SUBTOTAL function in Excel is very helpful to analyze data of provided range.
The SUBTOTAL Function allow to make filter and then perform
various other Excel functions such as SUM, COUNT, , COUNTA, PRODUCT, AVERAGE,
MAX, etc.
Use the SUBTOTAL function to exclude filtered or hidden rows
when calculating a total on the worksheet.
Syntax :
There are two steps to use the SUBTOTAL function in excel. These are:
1. Formatting and sorting of the provided data.