Excel Functions

Excel SUBTOTAL Function

Pinterest LinkedIn Tumblr

The SUBTOTALfunction returns an aggregate result for supplied values. The SUBTOTAL function can either include or exclude values in hidden rows.

Purpose of Excel SUBTOTAL Function

Get a subtotal in a list or database.

Return value

A number representing a specific kind of subtotal.


= SUBTOTAL (function_num, ref1, [ref2], …)


function_numA number that specifies which function to use in calculating subtotals within a list.Mandatory
ref1A named range or reference to the SUBTOTAL. Mandatory
ref2A named range or reference to the SUBTOTAL.Optional


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment