AGGREGATE FUNCTION IN EXCEL - SUM | AVERAGE | COUNT| MAX | MIN etc.

The aggregate function allows you to apply other aggregate functions with the option to ignore hidden rows, error values etc. This video shows you how it can be applied