-----Original Message-----
Hi,
Can anybody please tell me how to remove the #DIV/0!
error when my cells
show a 'zero' value.

I have a calculation in cell W7 which is =SUM(U7/T7)*100

where U7 has a calculation of =SUMPRODUCT(--
A$3:$A$1000=1),--($N3$N$1000="Y"))

where W7 has a calculation of =SUM(U7/T7)*100

I think it is something to do with the 'IF' statement but
can't work it out

thanks in advance

Anthony
.

Try this

+if(iserror(Sum(U7/T7*100)),"0",(Sum(U7/T7*100)))
hope this works