help with average formula
Options
gjav
✭
Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the numbers in the column using a formula?
Comments

If you only have the criteria of excluding "INDEX DATA", you can use the AVERAGEIF function.
=AVERAGEIF([Average Column]:[Average Column], @cell <> "INDEX DATA", [Average Column]:[Average Column])

Paul thank you for trying to help but that formula didn't work. I provided a screen shot of the column I am trying to average, W/O Time Lapse column.

I am unable to see any screenshots. Could you try reposting it?

figured it out thank you!
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!