Why Excel Pros LOVE the AGGREGATE function in Excel!

[@omt2526]

Great, very useful, i subscribed , merry christmas 🙂

[@Computergaga]

@@omt2526 Thank you very much. Great to hear.

[@merrillmchenry1450]

Very cool and useful!

[@naveedyousaf1657]

Brilliant 👏

[@kebincui]

Excellent! 👍 Thanks Alan. Merry Christmas.

[@Computergaga]

Thanks Kebin 😃

[@bryancamareno2831]

Brilliant! Thank you! I didn’t know the AGGREGATE function was so useful. I especially liked the SUMIFS example. Didn’t know you could do that with a spill range! Merry Christmas! 😁

[@Computergaga]

Thanks, Bryan 👍

[@silvestrecamposano6317]

Thank you!.

[@Computergaga]

You're very welcome

[@markbainbridge3240]

Excellent will definitely be using this going forwards.

[@Computergaga]

Thank you Mark.

[@wmcnabb]

Awessome Allan. Merry Christmaaas to you sir

[@Computergaga]

Thank you, Wyatt. Much appreciated. Merry Christmas to you too.

[@gruma6581]

Agreggated ignoring hidden values is fantastic

[@Computergaga]

Oh yes! 🔥

[@IvanCortinas_ES]

Thank you, Alan. The link is broken, review please. And Merry Christmas!!!!

[@Computergaga]

Thanks, Ivan. Merry Christmas to you. Which link? I checked the practise file, and it downloaded fine.

[@txreal2]

Why use AGGREGATE() in Subtotal? SO THAT IN Grand Total later at the bottom YOU CAN IGNORE AGGREGATE() Subtotal's above it BECAUSE YOU CAN'T IGNORE SUM() Thanks. MERRY CHRISTMAS!

[@Computergaga]

Merry Christmas. Thank you.

[@aliab2201]

What!🤯

[@Computergaga]

😃