Hi ims,

Just realised you were having a problem when there is less than 4 values in
the range. Replace your formula with this one.

=IF(COUNTBLANK(E16:E43)=29,"",IF(ISERROR(AVERAGE(L ARGE(E16:E43,{1;2;3;4}))),"",AVERAGE(LARGE(E16:E43 ,{1;2;3;4}))))

Trevor

" wrote:

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