Functions
SUBTOTAL
Apply function to a list (not supported with arrays)
When to use it
When should I use SUBTOTAL instead of SUM or AVERAGE?
Use SUBTOTAL when you want to apply a summary function (sum, average, count, etc.) to a list using a numeric function code, which lets you switch the aggregation type dynamically.
Used in
Syntax
SUBTOTAL(function_code, ref1, ...)