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