| 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 |
| 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) | |||
Threaded Mode
