View Single Post
  #1   Report Post  
Teri
 
Posts: n/a
Default ARRAY FORMULA-RETURN 0 INSTEAD OF #DIV/0

Here is my array formula. I would like it to return a ZERO instead of
#DIV/0. Have spent way too much time trying to make it work and thought some
kind soul out there would be willing to help me:

{=AVERAGE(IF(H3:H6<0, H3:H6,""))}

Thanks in advance!