=IF(COUNTIF(A2:C2,0)=3,0,SUMPRODUCT(--(A2:C2<0),A2:C2)/COUNTIF(A2:C2,"<0"))

------------------
mama no teeth

"Lisa" wrote:

This is what I'm trying to do, but it wont work. I have a workbook with over
500 entries and my formula is an array. Is there a way to do the arrays w/o
having to do the Ctrl+Shift+Enter each time?

Example:
0 5 5 my formula is =AVERAGE(IF(a2:c2<0,a2:c2,""))

Also, is there a way to make the array return 0 if all the columns are 0? I
can't seem to get it to work.

Thanks!