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...