Microsoft Excel - AGGREGATE (19 Functions & 8 Behaviors in 1 Function)

Learn about the amazing AGGREGATE function. This single function replaces the need for 19 other functions, while also providing a host of controls for handling hidden data, errors, and redundant calculations. It's the successor to the SUBTOTAL function, which was already amazing to begin with. File Download Link: https://www.bcti.com//wp-content/YT_Downloads/BCTI_Aggregate.xlsx 00:17 The SUM Function's Weakness 00:58 The SUBTOTAL Function 01:45 SUBTOTAL with Errors 02:09 The AGGREGATE Function 02:57 SUBTOTAL Codes 03:22 Ignoring Other SUBTOTAL Calculations 04:30 AGGREGATE Function Error Handling 05:19 AGGREGATE Function Codes 07:09 Examples of Every AGGREGATE Function 08:01 Testing Functions and Behaviors Dynamically 10:39 Getting Help with Switch Meanings