Returns SUM, AVERAGE, STDEV, etc. results for filtered data.
Syntax:
SUBTOTAL(function; range)
range is the overall range from which cells for calculation are selected by filtering.
function is a number that specifies the function to calculate, as follows: