IF and AVERAGE

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
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!
Click to expand...

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

where rng is your reference to the column of numbers.




--ron
 
Back
Top