If you don't have negative values

=SUM(A1:A10)/MAX(1,COUNTIF(A1:A10,"0"))

or

=AVERAGE(IF(A1:A10<0,A1:A10))

confirmed with CTRL+SHIFT+ENTER


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=561839