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.

[@davidfletcher9526]

Love it!! have used so many of your tips and tricks to semi-automate in my daily tasks!! cheers!

[@Computergaga]

Thank you, David. Your comments are very appreciated.

[@NAVEENSHARMA-k3n]

Respected honorable Allan Sir, I have been watching your videos from a year or so. I found you very knowledgeable and truly a pro in excel and teaching field. I already purchased your udemy course and I am obliged to you for such an amazing course. I am from India and we give show respect to elders by touching their toes. So I bow down to you for an amazing lessons you always taught to us.

[@Computergaga]

Thank you very much for your comments Naveen. Much appreciated.

[@NAVEENSHARMA-k3n]

@@Computergaga ❤❤❤❤❤❤❤

[@Bhavik_Khatri]

Very nice tutorial.

[@Computergaga]

Thank you very much!

[@kebincui]

Excellent! 👍 Thanks Alan. Merry Christmas.

[@Computergaga]

Thanks Kebin 😃

[@PaulEBrownbill]

Very useful, thanks Paul

[@Computergaga]

Cheers, Paul.

[@Aichauer]

excellent video!👌

[@Computergaga]

Thank you very much 😀

[@lourdesdelcampo8722]

Merry Christamas and Happy New Year, thank you for everything

[@Computergaga]

You're very welcome. Thank you!

[@markbainbridge3240]

Excellent will definitely be using this going forwards.

[@Computergaga]

Thank you Mark.

[@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 👍

[@nnamdiofodile2507]

Dear Sir, The DYNAMIC FUNCTION SELECTION & UNLOCKING OTHER FORMULAS TO USE SLICERS are a stroke of genius, it blew my mind. I am going to run riot with this technique going forward. Thank you for this, I shall proceed to follow your channel now. Happy holidays & God bless. 😎

[@Computergaga]

Thank you very much 😃

[@merrillmchenry1450]

Very cool and useful!

[@Computergaga]

Thank you!

[@naveedyousaf1657]

Brilliant 👏

[@Computergaga]

Thank you, Naveed.

[@ExcelWithChris]

Love it!!! Thanks.

[@Computergaga]

Thanks, Chris.

[@joshuamanampiu6489]

Brilliant

[@Computergaga]

Thank you!

[@wmcnabb]

Awessome Allan. Merry Christmaaas to you sir

[@Computergaga]

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

[@silvestrecamposano6317]

Thank you!.

[@Computergaga]

You're very welcome

[@NAVEENSHARMA-k3n]

I wish I could promote your channel more. Although i always share your videos link to my friends and all, let me tell you sir that you should have millions of subscribers. I have seen some excel youtubers who have millions of subscribers although they should not have more than thousands and those thousands would be like him only. Carry on your journey. God always blesses and loves to see more subscribers in the coming days...

[@Computergaga]

I will carry on. Thank you, Naveen. It is great to know that my videos are appreciated.

[@NAVEENSHARMA-k3n]

@@Computergaga 😍😍😍❤❤❤

[@ladokhvleuri2376]

Very good example. Only I wonder why doesn't excel suggests us aggregate with direct sumifs within it?

[@Computergaga]

Thank you! Cool thing is we can use any other formula with AGGREGATE so the possibilities are endless.

[@MUAISC]

Cool bro

[@Computergaga]

Thanks! AGGREGATE is very cool.

[@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]

😃