={AVERAGE(IF(J7:J21<>0, J7:J21,""))}

Trying to use a array formula similar to the above to calculate an average of numbers from a column without including zero value fields in the average. but I am not successful.

Any ideas