Make Function ignore 0 and error values

A

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.
 
T

Teethless mama

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

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