Empty cells are not equal to zero.

=SUM(F35:U35)/(COUNTIF(F35:U35,"0")+COUNTIF(F35:U35,"<0"))

is more bullet proof.

Jerry

Jason Morin wrote:

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