Averages with Errors
Options
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,
Tim
Tags:
Comments
-
average(collect([Avg. Functionality]1:[Avg. Functionality]16,[Avg. Functionality]1:[Avg. Functionality]16,isnumber(@cell))
-
Thank you. I tried this out, but it's still giving me an unparseable error.
-
Did you make sure your data is all stored as numbers? To do this you can add a temporary extra column and use
=if(istext(Cellref),1,0)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
