I am looking for a formula that will compute an average of a number of non
contiguous cells such as G8, G16, G24, G36, etc. Each of these cells has a
formula which computes an average of a range of cells. With the helpm of
this forum, I have been able to find a formula which does that AND uses
values only when they are greater than zero and does not display #DIV/0!.
But I cannot fin a fromula that will do the next step- Take an average of
those specific cells AND use only the ones where the cell is 0, Example
G8=100, G16=85, G24 is blank, G36=75, then this formula would calculate the
average 100+85+75/3.

All help greatly appreciated
--
dbconn