Your reports should remain stable even when your data gets messy. AGGREGATE is the only function that survives both filtered ...
You don't need complex formulas to summarize thousands of rows when PivotTables can do the heavy lifting for you.