Hi ras - enter this as an array formula (use ctrl+shift+enter instead of
just enter)
=AVERAGE(IF(A1:A9<0,A1:A9,""))


Alan P.

"ras711" wrote in message
...
Have set up a range named DataOpen. Within the range are numbers & 0. Do
not
want to average the cells that contain 0's

Thank You!