I want to average my column but exclude the zeros from my average

Options

I Am trying to put an average on a column but i want it to exclude the zeros. Further down my list towards the bottom i have zero's. Is there an AVGIF function that will allow me to only include it in my avg if there is a value more than zero?

=AVG([Total Truck Invoice Value (Scott)]4:[Total Truck Invoice Value (Scott)]88)


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!