SUBTOTAL
Returns a subtotal in a list or database.
Math & TrigonometryMath Basics
What it does
Calculates aggregate (Sum, Count, etc.) ignoring filtered rows.
Syntax
SUBTOTAL(function_num, ref1, ...)
Arguments
function_num(number) — 1-11 (includes hidden), 101-111 (ignores hidden).ref1(range) — Range.
Examples
Filtered Sum
Sum visible cells.
FORMULA
=SUBTOTAL(109, A2:A10)
RESULT
500
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 100 |
| 3 | 200 |
| 4 | (Hidden) |