i've been a bit stumped with this MS Excel issue of mine and i can't recall how to work around this. here's the situation. i have a column that i want to average, and that column is based on each member cell's respective rows where those rows form parts of the equation in each column. for example, cell G6 of column G will have the equation:

=(C6*B6+D6+E6)/B6
and this goes on for a few cells of column G. and then they will be averaged like this, let's say, on cell G18:

=AVERAGE(G6,G7,G8,G9,G10,G11,G12,G13,G14,G15)
the thing is, if for example if G6 has no valid data on it, it'll give "#DIV/0!". this would then give the average on G18 as "#DIV/0!" as well. aside from manually inputting which column cells to consider (which makes the entire table well...tedious, is there a way to tell excel that for example, if G6 has no data, then to exclude it from the computation, like an "IF G6=0 THEN do not include in AVERAGE...yadda yadda"?

thanks in advance. :D