Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=AVERAGE(IF((MOD(COLUMN(B5:H5),2)=0)*(B5:H5<0),B5 :H5))

Biff

"Cheri" wrote in message
...
One row would be averaging what is in cells b5, d5, f5, and h5.

I look forward to your response! 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