Averages with Errors

Tim Möhle
edited 12/09/19 in Formulas and Functions

Hello, I'm trying to take an average of a range of cells.  Some of these cells have a #Divide By Zero error in them because the source sheet does not yet have applicable data.

I have used an IFERROR statement to change these cells into "blank" cells, yet when I use the following formula:

=AVERAGE([Avg. Functionality]1:[Avg. Functionality]16)

it returns an #UNPARSEABLE error.

See screenshot.

Thanks for any help,





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!