Hide Divide by Zero Error

Katye Reed
Katye Reed ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

I am having issues with creating the correct formula that calculates the average of the children rows while hiding the divide by zero errors for columns that do not have any data. 

Could someone please help? I tried the following 

=IFERROR(AVG(CHILDREN([Column]@row],"")))

Thanks so much!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!