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


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!