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

ECD Auto Design

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)

Kimberly Loveless

Yes I think if you did

=AVERAGEIF([Total Truck Invoice Value (Scott)]4:[Total Truck Invoice Value (Scott)]88, @cell > 0)

it should work

Kimberly Loveless

Yes I think if you did

=AVERAGEIF([Total Truck Invoice Value (Scott)]4:[Total Truck Invoice Value (Scott)]88, @cell > 0)

it should work

ECD Auto Design

Thank you @Kimberly Loveless That was it!