avergaing formulas

  • Thread starter Thread starter Carole
  • Start date Start date
C

Carole

Is there a formula that will average a range of numbers
excluding zero's. I have a range of data, let's say cell
A1 through Z1 and most of those cells are poulated with
number greater than zero but some cells have zero values.
I want to exclude these from averaging, I also can't
delete them so that really is not an option
 
=AVERAGE(IF(A1:Z1,A1:Z1))

which you input with control+shift+enter, not just with enter.
 
I'm Sorry it really didn't work I thought it did because
had it from A1:A1 WHEN I ENTERED THE CORRECT FORMULA IT
ALSO CALCULATED THE FIELDS WITH ZERO ZEROS, I DON'T WANT
THOSE FIELDS TO BE THROWN IN.
 
Back
Top