Hi James

Assuming your range is A1:A50
the formula would be
=AVERAGE(IF(A1:A50<0,A1:A50))
entered using CONTROL & SHIFT & ENTER

Hope this helps

--
Cheers
JulieD

julied_ng at hctsReMoVeThIs dot net dot au


"James" wrote:

Hi,

I have a column of numbers, some of which are zero.

I want to obtain the average of the numbers in the column and exclude the
zeros from the calculation.

Thanks!