Hi DaveB,

Thank you for the assistance. My problem is that there is other data in the
cells that are adjacent, so I cannot use a range. It must average different
specific cells in a row only if the cell does not contain a zero.

Thanks,
Cheri


"DaveB" wrote:

Hello -
This formula will work, assume your values are in the range A1:A1000:

=AVERAGE(IF(A1:A1000<0,A1:A1000,""))

This is an array formula so enter it in using ctrl+shift+enter.

--
Regards,

Dave


"Cheri" wrote:

I have a spread sheet with data in non-adjacent cells. I would like to
average the data in the cells only if the cell does not contain a zero. How
would I do this?

Your help is greatly appreciated!!!

Cheri