⬇️ Download free Excel example file: https://bit.ly/fn-agg1

The AGGREGATE function is the Swiss Army Knife of functions; it’s so versatile it can replace these 19 Excel functions in one fell swoop:

AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV.S, STDEV.P, SUM, VAR.S, VAR.P, MEDIAN, MODE.SNGL, LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC

But that’s not reason enough to use it, the function-killer reason to use AGGREGATE over any of the 19 standard functions it can replace is because it is far more powerful. Let me show you.

LEARN MORE
===========

🏫 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

📰 EXCEL NEWSLETTER - join 320K+ subscribers here: https://www.myonlinetraininghub.com/e...

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 FOLLOW me on LinkedIn:   / myndatreacy  

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...

⏲ TIMESTAMPS
==============
0:00 The Swiss Army Knife of functions
0:19 The problem with other functions
1:00 Array or Reference Form
1:54 Handling arrays
2:59 Exploiting errors
4:38 Caution
5:03 Limitations

#excelfunctions #excelformula #exceltutorial