In addition to Leo's array formula, you also have the
option of using:
=SUM(F35:U35)/COUNTIF(F35:U35,"<0")
so long as your range does not contain any empty cells or
non-numerical values.
HTH
Jason
Atlanta, GA
-----Original Message-----
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
.
|