The subtotal function is used to find the subtotal of the numbers in a column.
Dec 17 2013 03:12 PM
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.