Hi
try
=IF(COUNT(E9:I9),(SUM(E9:I9)*100/COUNT(E9:I9))/10,"")

--
Regards
Frank Kabel
Frankfurt, Germany

"Jean-Paul De Winter" schrieb im Newsbeitrag
...
Hi,

Following formula works perfect but of course returns a DEVIDE/0!
error
when cells E9 trough I9 are all empty

=(SUM(E9:I9)*100/COUNT(E9:I9))/10

How to avoid this error?
Thanks