Subtotal() is basically used to get instant summary of a filtered data table. It is used with the support of AutoFilter tool or can be used alone. If you use AutoFilter for Subtotal then all hidden rows become visible. But if you do not use AutoFilter then hidden rows becomes hidden. Subtotal Function: The Subtotal function structure is: =SUBTOTAL(function_number,ref1) Function Details: There are 2 main parts of this function. These are: function_number: Subtotal function can calculate many things like, SUM, COUNT, AVERAGE etc. Each of these function are stored with a number in Subtotal(). What you need to do is mention the Number first from below list: Image 1: SUBTOTAL() number chart ref1: This is nothing but a Range. You can Select a single cell or few cells selected randomly, or a range of cells. Example: Based on below data table assume that, you need to know the Salary of Mr. A in D4 cell. Image 2: Sample data table for Subtotal In D4 ce...
Learn Microsoft Excel with step by step tutorials including charts, formulas, functions, Power BI, Excel VBA for beginners.