Hi Geo

This array formula will do the job:

=AVERAGE(IF(F35:U35<0,F35:U35))

To be entered with <Shift<Ctrl<Enter instead of <Enter,
also if edited later.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Geo" skrev i en meddelelse
...
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