Adding error suppression to AVERAGE FUNCTION

[plb2862]

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

 

[plb2862]

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

 

[jlepack]

Try this:
=IF(ISERROR(AVERAGE(B15:H15))," ", AVERAGE(B15:H15))

Cheers,
Jason Lepack

 

[plb2862]

Try this:
=IF(ISERROR(AVERAGE(B15:H15))," ", AVERAGE(B15:H15))

Cheers,
Jason Lepack

Works perfectly. Thank you