View Single Post
  #1   Report Post  
Geo
 
Posts: n/a
Default EXcluding Zeros from the average in a row

HI
I am trying to average a row of numbers (F35:U35) that have numeric zeros in
some of the cells. However, I would like to exclude them, and the cells from
the calculation "=AVERAGE(F35:U35)". Is there a way to do that?

Thanks
--
Geo