Make Function ignore 0 and error values

[AD108]

I am trying to make the average function ignore 0's and errors. The
following array formula works to ignore the 0's, but I got stuck trying to
make it ignore errors.

=AVERAGE(IF((G3:G20)<>0,G3:G20))

=AVERAGE(IF(AND((G3:G20)<>0,ISERROR(G3:G20)=FALSE),G3:G20))

Thanks in advance.

 

[Guest]

=AVERAGE(IF(ISERROR(G3:G20),"",IF(G3:G20<>0,G3:G20))

Array formula you have to commit ctrl>shift>enter (not just enter)

 

[Guest]

Non array enter

=SUMIF(G3:G20,">0")/COUNTIF(G3:G20,">0")

 

[AD108]

Thanks very much,

Non array enter

=SUMIF(G3:G20,">0")/COUNTIF(G3:G20,">0")