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)
Help Article Resources
Check out the Formula Handbook template!