Learn how to use some of the new Aggregate function's 19 calculations and options to create a result that can exclude hidden rows, filtered rows, and cell errors. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values. In this video, you will learn the benefits of using the Aggregate function over the Subtotal function.
