How to Remove #DIV/0 Error in Excel
If you’re an Excel user, you’ve probably encountered the dreaded #DIV/0 error at some point. This error occurs when you attempt to…
Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function
There are many areas within business reporting where we are looking for the average of a selection of results. A good example…
How to Sum only visible cells in Excel when using Filter
A common question I get asked when I’m teaching people how to filter data is “how do I sum only the visible…