Hi Lightning,

The Average function ignores empty cells, so try:

= Average(J7:J21)

---
Regards,
Norman



"lighting" <lighting.20242a_1134608701.0233@excelforum-nospam.com> wrote in
message news:lighting.20242a_1134608701.0233@excelforum-nospam.com...
>
> ={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
>
>
> --
> lighting
> ------------------------------------------------------------------------
> lighting's Profile:
> http://www.excelforum.com/member.php...o&userid=29656
> View this thread: http://www.excelforum.com/showthread...hreadid=493664
>