This Excel tutorial explains how to use the Excel SUBTOTAL function with syntax and examples.
The Microsoft Excel SUBTOTAL function returns the subtotal of the numbers in a column in a list or database.
The syntax for the Microsoft Excel SUBTOTAL function is:
SUBTOTAL( method, range1, [range2, ... range_n] )
The type of subtotal to create, but be careful which method you select. method can be a value ranging from 1 - 11 that includes hidden values or a value ranging from 101 - 111 that ignores hidden values in the calculation.
The SUBTOTAL function can be used in the following versions of Microsoft Excel:
The SUBTOTAL function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel SUBTOTAL function examples and explore how to use the SUBTOTAL function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following SUBTOTAL examples would return:
=SUBTOTAL(1, D2:D5) Result: 22.3925 =SUBTOTAL(2, D2:D5) Result: 4 =SUBTOTAL(3, D2:D5) Result: 4 =SUBTOTAL(4, D2:D5) Result: 35.88 =SUBTOTAL(5, D2:D5) Result: 7 =SUBTOTAL(6, D2:D5) Result: 136191.51 =SUBTOTAL(7, D2:D5) Result: 11.91825316 =SUBTOTAL(8, D2:D5) Result: 10.32151 =SUBTOTAL(9, D2:D5) Result: 89.57 =SUBTOTAL(10, D2:D5) Result: 142.0447583 =SUBTOTAL(11, D2:D5) Result: 106.5335688
(scroll to see more)