Save UP TO 70% on Drinks & Water
*available only online
The in Excel is a versatile formula designed to perform various calculations—such as summing, averaging, or counting—on a range of data while intelligently handling hidden rows and filtered lists. Unlike standard functions like SUM, the SUBTOTAL function can automatically ignore rows hidden by a filter and prevents "double counting" by ignoring other SUBTOTAL formulas within its range. Core Syntax and Arguments
The formula for the SUBTOTAL function is: =SUBTOTAL(function_num, ref1, [ref2], ...) subtotal function in excel
Up to 254 additional ranges or references. The Two Sets of Function Numbers SUBTOTAL function - Microsoft Support The in Excel is a versatile formula designed
A number from 1 to 11 or 101 to 111 that specifies which math operation to perform (e.g., 9 for SUM, 1 for AVERAGE). The Two Sets of Function Numbers SUBTOTAL function
The first named range or cell reference you want to subtotal.
