Excel's AVERAGE function – the hidden pitfalls

AVERAGE is one of those easy functions in Excel. Like, super easy! It has just one argument, the cells, or numbers to be averaged.

So what's the problem? It's too easy to get wrong, yet we might not notice for weeks, months, years or ever.

There are many ways to calculate an average. Different formulas will fit with different datasets and scenarios. The critical thing is to know your data and exactly what you want to achieve.