Forum Discussion
Solved
Removing or hiding errors
Hi there, Can anyone help please as this is driving me nuts! If so, could you take a look at the screenshots below - I have included the formulas for you to see. I am creating a document for ...
To exclude errors you may use something like
=AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!")Average in any case returns number. If nothing except errors then zero. To have empty string you may wrap it as
=IF( AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!"), AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!"), "" )
To exclude errors you may use something like
=AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!")
Average in any case returns number. If nothing except errors then zero. To have empty string you may wrap it as
=IF( AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!"), AVERAGEIFS(S8:Y8, S8:Y8, "<>#DIV/0!"), "" )
Thank you so much for taking the time to reply - it's fixed!