ExcelBanter - Devide/0 error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Devide/0 error (https://www.excelbanter.com/excel-programming/313712-devide-0-error.html)

Jean-Paul De Winter

Devide/0 error

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

Frank Kabel

Devide/0 error

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

All times are GMT +1. The time now is 05:01 PM.