Remove #DIV/0! error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

=SUM(U7/T7)*100

===>

=(U7/T7)*100
 
-----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
.
Click to expand...

Try this

+if(iserror(Sum(U7/T7*100)),"0",(Sum(U7/T7*100)))
 
Back
Top