Calculate average - ignore ZERO and N/A

[lawi227]

I have this equation that ignores N/A errors:
{=AVERAGE(IF(NOT(ISNA(E4:E10)),E4:E10))}

It is an array formula. I would also like it to ignore ZERO values.

Thanks!

 

[Tetra201]

Array formula:

=AVERAGE(IF(ISNUMBER(1/E4:E10),E4:E10))

 

[Jonmo1]

Which version of Excel are you using?
XL2007+ try

=AVERAGEIFS(E4:E10,E4:E10,"<>0",E4:E10,"<>#N/A")