Adding error suppression to AVERAGE FUNCTION
 

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

Adding error suppression to AVERAGE FUNCTION
 

"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

Adding error suppression to AVERAGE FUNCTION
 

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

Cheers,
Jason Lepack

plb2862 wrote:
"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

Adding error suppression to AVERAGE FUNCTION
 

"jlepack" wrote in message
ups.com...
Try this:
=IF(ISERROR(AVERAGE(B15:H15))," ", AVERAGE(B15:H15))

Cheers,
Jason Lepack

plb2862 wrote:
"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


Works perfectly. Thank you