| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display output as blanks with average and large value set
Hi All,
I haven't a bit of problem displaying a blank cell in D15 as empty when the others cells are empty. The value that display is ######. Anyone there that can help me! Here is the formula: - =IF(COUNTBLANK(D16:D43)=29,"",AVERAGE(LARGE(D16:D4 3,{1;2;3;4}))) The formula works fine and display the average of the largest set of 4. The only problem is displaying D15 as empty. Many thanks ims |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average with out zeros or blanks | Excel Discussion (Misc queries) | |||
| average in non-continuous set, excluding blanks | Excel Worksheet Functions | |||
| Moving Average with Blanks | Excel Discussion (Misc queries) | |||
| Formula for average of cells that have blanks | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
Threaded Mode
