Hi!

Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER:

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

Biff

"Stephen" wrote in message
...
How do I average a column of numbers and exclude cells with zero values?