SUBTOTAL

Returns a subtotal based on the specified type of calculation and the cells to use. The function doesn't include values from hidden rows (but it does from hidden columns), depending on the aggregation specifier. The function doesn't include values from rows that have been filtered out. A value that's the result of, or includes, a SUBTOTAL() function isn't included in the new SUBTOTAL(). If you specify multiple ranges, then the function includes all values from the ranges in the final aggregation.