SUBTOTAL FUNCTION



0
HOW TO USE SUMTOTAL FUNCTION

1 Answer(s)


0

The subtotal function is used to find the subtotal of the numbers in a column.

Its syntax is SUBTOTAL( method, range1, [range2, ... range_n] )

There are many "methods" such as sum, average, max, min etc.

As you type the formul into excel, the drop down will guide you on how to craft the formula.