"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