Which function is not a Subtotal function?
A)MAX
B)SUM
C)AGGREGATE
D)AVERAGE

Question

Quizplus · Accepted Answer

AGGREGATE is not a Subtotal function. It is a function designed to return aggregate results (like sum, average, count, etc.) while allowing options to ignore hidden rows, error values, or nested SUBTOTAL and AGGREGATE functions. SUBTOTAL function, on the other hand, specifically offers a set of predefined operations like SUM, AVERAGE, MAX, etc., and is used for similar purposes but with a more limited scope and functionality compared to AGGREGATE.

Which Function Is Not a Subtotal Function