Hi!

Hmmm....

The formula DOES work! I'll send you a sample file to prove it if you'd
like!

Did you make sure to enter it as an array?

I can't duplicate what you're describing and it's working just fine for me.

Biff

"Cheri" wrote in message
...
No, that didn't work <frown If I input 95% and 100% in two of the cells
the
answer with the first formula returns a correct average of 97.5%. With
this
formula it returns a 96.2% and if I empty the cells or place a zero in
them,
the 96.2% stays in the cell. I'm sure I should do something that would
update it, but it didn't recalculate on its own.

Thanks for trying...I can live with the #DIV/0!...it just isn't pretty
<smile

Thanks!!!



"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