Excel’s AVERAGE function – the hidden pitfalls

Excel’s AVERAGE function – the hidden pitfalls

17 April 2018

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.