"plb2862" wrote in message
...
How would I combine these two formulas to give me an average of non empty
cells in a range and when copied down to not display a #DIV/0 error.

This formula takes care of the "not display a #DIV/0 error".
=AVERAGE(IF(ISERR(B15:H15),"",B15:H15))

And, this formula takes care of averaging the non-empty cells.
=AVERAGE(IF(B15:H15<0,B15:H15,FALSE))

Thank you


I forgot to mention, I've tried combining the two
{=AVERAGE(IF(ISERR(B15:H15),"",=AVERAGE(IF(B15:H15 <0,B15:H15,FALSE))))}
but I stillget the #DIV/0 error when I copy the formula down.

Thanks again