How To Aggregate?
The AGGREGATE function returns the result of an aggregate calculation like AVERAGE, COUNT, MAX, MIN, etc.Behavior options. Option Behavior 2 Ignore error values, SUBTOTAL and AGGREGATE functions 3 Ignore hidden rows, error values, SUBTOTAL and AGGREGATE functions 4 Ignore nothing 5 Ignore hidden rows How do you calculate aggregate? Answer. Take total of all marks […]