averages without including zero values

={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

I use the below formula and it works fine for me. I had to add the first section to stop an error I recieved when all the fields were empty.

=IF(SUM(j7:j21)=0,"",AVERAGE(IF(j7:j21<>0, j7:j21,"")))

Hope it helps