SUBTOTAL Function in Excel: Syntax, Examples and Free Practice
SUBTOTAL is an Excel Math & Trig function. Performs a calculation like SUM or AVERAGE while ignoring other subtotals in the range.
SUBTOTAL syntax
Arguments
function_num: A code identifying which calculation to perform (e.g. sum, average)ref1: The range to include in the calculation
When to use SUBTOTAL
SUBTOTAL is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice SUBTOTAL online, free
Open the live Excel-style spreadsheet and try SUBTOTAL yourself. No Excel install or sign-up needed to start.
Practice SUBTOTAL now →Watch: SUBTOTAL in Excel
More Math & Trig functions
Frequently asked questions
What does the SUBTOTAL function do in Excel?
Performs a calculation like SUM or AVERAGE while ignoring other subtotals in the range.
What is the syntax of SUBTOTAL in Excel?
The syntax is =SUBTOTAL(function_num, ref1, ...). function_num: A code identifying which calculation to perform (e.g. sum, average); ref1: The range to include in the calculation.
Where can I practice SUBTOTAL online for free?
Open the free live spreadsheet on Cellgrids and try SUBTOTAL yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts