SUBTOTAL function in Excel

SUBTOTAL returns the sum, count, average… that skips filtered-out rows (109 = SUM).

Syntax

=SUBTOTAL(function_num, ref1, …)

Argument	Required?	What it is
function_num	Required	Which calculation to run: 9 or 109 for SUM, 1/101 AVERAGE, 2/102 COUNT, 4/104 MAX, 5/105 MIN. The 100s ignore manually hidden rows.
ref1, …	Required	The range to calculate. Rows hidden by a filter are always skipped.

Type the formula yourself and get it graded instantly, no Excel needed.

SUBTOTAL returns the sum, count, average… that skips filtered-out rows (109 = SUM).

=SUBTOTAL(function_num, ref1, …)

Argument	Required?	What it is
function_num	Required	Which calculation to run: 9 or 109 for SUM, 1/101 AVERAGE, 2/102 COUNT, 4/104 MAX, 5/105 MIN. The 100s ignore manually hidden rows.
ref1, …	Required	The range to calculate. Rows hidden by a filter are always skipped.

Type the formula yourself and get it graded instantly, no Excel needed.