AI Commentary

Play the video to see AI commentary

Oh, this AGGREGATE function sounds super useful, especially the part about ignoring errors and hidden cells. That's a big upgrade from SUBTOTAL, which I always found a bit limited.

Yeah, that ignore option with AGGREGATE is key. The fact that SUBTOTAL couldn't handle error values is a classic pain point, so it's good to see that addressed. It makes calculations much cleaner.

This is where AGGREGATE really shines – ignoring hidden rows is a game-changer for dynamic reports. Being able to filter sums based on visible data without extra steps is incredibly efficient.

Want more insights? Sign up to see the full conversation

Video summary will appear here after you start watching

The AGGREGATE function, introduced early on [0:00], offers a powerful way to summarize data by allowing users to ignore error values and hidden cells, a significant improvement over the older SUBTOTAL function. This flexibility is demonstrated when summing amounts, where AGGREGATE can specifically exclude errors [0:30] or hidden rows [1:00], providing more accurate calculations. It's particularly useful for calculating profit before tax by summing specific ranges while ignoring other aggregated values [1:30].

Want to access full features?

Current Section Summary

Video summary will appear here after you start watching

Want to access full features?

Excel for Accounting - 10 - AI Video Analysis

AI Commentary

Current Section Summary