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

hI ALL,
Think I have answered my own question,
but thanks anyways

"Anthony" wrote:

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

If you copied your formula in U7 correctly, then that is where your problem
lies.
$N3$N$1000need a ":" between the 3 and the $N to be recognised.

"Anthony" wrote:

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 to avoid SUM around a simple division though...

=SUM(U7/T7)*100

===

=(U7/T7)*100

Anthony wrote:
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

-----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