How to use the SUBTOTAL Function to Sum, Average, Count, Maximum, Minimum, Product

This Excel tutorial explains how to use the Excel SUBTOTAL function step-by-step with syntax and examples.

Where to use ? Its a Math/Trig function, therefore, the use is as per your choice in calculations. You can easily calculate a lot of things using this function. Below is the few list of the value and their explanations.

Description

The Microsoft Excel SUBTOTAL function returns the subtotal of the numbers in a column in a list or database.

Syntax

The syntax for the SUBTOTAL function in Microsoft Excel is:

SUBTOTAL( function num, range1, [range2, ... range_n] )

function num

It is the number of the function listed within the function SUBTOTAL like, for AVERAGE number is '1', alternatively you can use comma. In simplier language it indicates the function used. Number '9' means SUM in this fuction as far as I can remember.

range1, range2, ... range_n

The ranges of cells that you want to subtotal.

The below image shows how this formula looks while applied sum, as you know '9' means the function SUM.