SUBTOTAL

Definition: The SUBTOTAL function in Excel is used to calculate a subtotal for a range of data using a specified function.

Syntax: ==SUBTOTAL(function_num, range).

Situation: This formula is appropriate in situations where you need to calculate a subtotal for a range of data using a specified function.

Example: If you have a range of data A1:A10 and you want to calculate the sum of the data, you would use the formula =SUBTOTAL(9, A1:A10). This would return the sum of the data in the range.