Getting errors on ignoring the error cells while calculating the average for the column

Hello all,

I've been trying to get an average for the column "Planning notified- QSTO generation". I want to ignore the #invalid data types cells and calculate the average of the column. I was suggested to use iferror but I'm not sure how to place this as a formula as it needs to return something if error is found. I need just to ignore those cells.


Any help is appreciated. Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!