# Divide By Zero Error with Average

Hi,

I'm trying to set up a formula that averages the scores for four columns, but doesn't bring up the Divide by Zero error if the scores haven't been entered yet (either leaves blank or puts a 0).

The Average formula works fine but I can't get the IFERROR part to work.

Current formula: =ROUND(AVG([LOR 1]1:[LOR 4]1), 1)

Thanks

• Try this:

=IFERROR(ROUND(AVG([LOR 1]1:[LOR 4]1), 1),"")

This should replace the error message with a blank.

Let me know if it works!

Best,

Heather

• Try this...

=IFERROR(ROUND(AVG([LOR 1]1:[LOR 4]1), 1), "")

• I am having the same issue, trying to average 5 rows in a metrics sheet where some of them contain #DIVIDE BY ZERO. I am using this formula, but it doesn't return any value, not even an error msg. If anyone can help, it would be much appreciated!

=IFERROR(AVG([Column2]22:[Column2]26), "")

• @Kariv You need to get the error removed from the cells you are referencing.

• @Paul Newcome ohhhhh that makes a lot of sense now! Thank you so much!

• Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!