Why Excel Pros LOVE the AGGREGATE function in Excel!

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

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

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

[@lourdesdelcampo8722]

Merry Christamas and Happy New Year, thank you for everything

[@Computergaga]

You're very welcome. Thank you!

[@Aichauer]

excellent video!👌

[@Computergaga]

Thank you very much 😀

[@omt2526]

Great, very useful, i subscribed , merry christmas 🙂

[@Computergaga]

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

[@Bhavik_Khatri]

Very nice tutorial.

[@Computergaga]

Thank you very much!

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

[@PaulEBrownbill]

Very useful, thanks Paul

[@Computergaga]

Cheers, Paul.

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

[@kebincui]

Excellent! 👍 Thanks Alan. Merry Christmas.

[@Computergaga]

Thanks Kebin 😃

[@merrillmchenry1450]

Very cool and useful!

[@Computergaga]

Thank you!

[@markbainbridge3240]

Excellent will definitely be using this going forwards.

[@Computergaga]

Thank you Mark.

[@naveedyousaf1657]

Brilliant 👏

[@Computergaga]

Thank you, Naveed.

[@joshuamanampiu6489]

Brilliant

[@Computergaga]

Thank you!

[@ExcelWithChris]

Love it!!! Thanks.

[@Computergaga]

Thanks, Chris.

[@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 😍😍😍❤❤❤

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

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

😃