you can use a pivot table, or auto filter with this condititional (greater
than 0) and in this case use =subtotal(1,a2:a500)

hth
regards from Brazil
Marcelo

"JimNColorado" escreveu:

I am trying to average a column of numbers. I want to only average the cells
that contain a number greater than 0. How do I do that?