I bet you meant to count numbers:
=IF(COUNT(D4:D8)=0,"",AVERAGE(D4:D8))
(Just in case there's text in those cells.)

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

--

Dave Peterson