IF and AVERAGE

[Guest]

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!

 

[Guest]

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

 

[Ron Rosenfeld]

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!

=SUM(rng)/COUNTIF(rng,"<>0")

where rng is your reference to the column of numbers.




--ron