=iF(COUNT(D9:G9)0,AVERAGE(IF(D9:G9<0,D9:G9)),"")
too late for me to test it!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"StephenAccountant" wrote in
message ...
here is my formula - it is an array formula.

=AVERAGE(IF(D9:G9<0,D9:G9))

if the cells all show up as blank or nil - i get a #Div/0! error - how can
I
stop that from happening?