Divide By Zero Error with Average



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)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!