=AVERAGE(IF(H2:H132<0,H2:H132)) is the function I wrote from your example
and I am still getting an error. Is there anything wrong with the function I
have typed?

Stephen


"Biff" wrote:

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?