Remove #DIV/0! error

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