Make Function ignore 0 and error values
Non array enter
=SUMIF(G3:G20,"0")/COUNTIF(G3:G20,"0")
"AD108" wrote:
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.
--
Remove 7 numbers to email
AD108
|