| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The sum and average function view all numbers as zero?? | Excel Discussion (Misc queries) | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Using text for the range in AVERAGE function | Excel Worksheet Functions | |||
| Calculate the average using the Lookup function or similar | Excel Discussion (Misc queries) | |||
| Average function assistance | Excel Discussion (Misc queries) | |||
Hybrid Mode
