Andy,

Thank you so much, it worked perfectly!

Cheers,

Rob,
Teesside,
UK

"Andy Brown" wrote:

"abfabrob" wrote in message
...
Hi,
Thanks for this. But I can't get it to work!
My formula is (literally):
=AVERAGE(D4:D8)

Try =IF(COUNTA(D4:D8)=0,"",AVERAGE(D4:D8))

HTH,
Andy