Hide the Div/0 error?

Originally Posted by Søren Larsen

You should rather use "" in the =IFERROR() formula instead of " ".

With regards to the "green marker", it does not appear because of the =IFERROR(); you will notice that if you select any cell with the =AVERAGE() calculation (and without =IFERROR()) and hit F2 and then Enter, the "green marker" also appears. It appears because Excel is telling you that there are values next to the range on which you are calculating the average that are not included in said range. Obviously in your case this is not a mistake, but Excel does not know that.

Oh right, so it's more of a notification that I've potentially missed cells from a calculation, rather than a notification telling me I've got an error with my formula.