How to Use SUBTOTAL in Excel: Function and Subtotal Tool Explained
- Tahir Abbas
- November 18, 2026
Excel has two things called subtotal, and people often confuse them. The SUBTOTAL function calculates a sum, average, count or other result for a list, and it can ignore rows hidden by a filter. The Subtotal command on the Data tab inserts subtotal rows into a sorted list, one for each group, with an outline

