Average calculation in Excel, but with a twist 🥨

How would you calculate average when the data doesn't cooperate?
In this short but insightful video, learn how to use AVERAGEIFS, FILTER, and a good ol' array formula to solve this pesky problem. I hope you will use it one day to save the universe (or a few planets).

⏱ In the video
=============
0:00 - The average problem
1:24 - Using FILTER (with Excel 365)
2:15 - Using array formulas (in all versions of Excel)
4:00 - My recommendation

📁SAMPLE FILE:
==============
Need to practice this concept? Get the sample file here - https://chandoo.org/wp/wp-content/uploads/2022/09/not-so-average.xlsx

👌 Learn more
============
FILTER function with my clone - https://youtu.be/JuTdj2j-9Kg
SUMIFS 10 advanced tricks - https://youtu.be/YEt-aYbDTrs
SPILL RANGES - https://youtu.be/kR6czKY4FEw
Excel formula examples & tips - PLAYLIST - https://www.youtube.com/watch?v=Y3DEt7P62G8&list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_

~

On average one out of 1000 viewers read this message. If you are the one, you are AWESOME 😍

#exceltips

Видео Average calculation in Excel, but with a twist 🥨 канала Chandoo