=SUMIF(A2:E2,"<0")/COUNTIF(A2:E2,"<0")

you can also use an array formula like


=AVERAGE(IF(2:2<0,2:2))

entered with ctrl + shift & enter


--


Regards,


Peo Sjoblom



"Matt" wrote in message
...
How can I get a average of a row without the cells that contain 0?