Excel Function

SUBTOTAL

Returns a subtotal with specified aggregate function.

SUBTOTAL(function_num, ref1, [ref2], ...)

Arguments

function_num

Required

SUBTOTAL operation code: 1=AVERAGE, 2=COUNT, 3=COUNTA, 4=MAX, 5=MIN, 6=PRODUCT, 7=STDEV.S, 8=STDEV.P, 9=SUM, 10=VAR.S, 11=VAR.P. Use 101-111 for the same operations while excluding manually hidden rows.

ref1

Required

Specify a reference range. You can drag or click start/end cells.

Practice Preview

summarize sales data. Use SUBTOTAL to Returns a subtotal with specified aggregate function. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use 9 for function_num. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SUBTOTAL(9, D2:D8)

Practice This Function

Practice in Sequential Mode Back to Function List