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

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

Any idea

--
lightin
-----------------------------------------------------------------------
lighting's Profile: http://www.excelforum.com/member.php...fo&userid=2965
View this thread: http://www.excelforum.com/showthread.php?threadid=49366

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


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=493664