Formula issue

K

kelljeff

I can't get this to work...

{=SUM(((B5*(IF(Sheet!$A$2:$A$126=$A5,Sheet!$N$2:$N$126,0))/3600))/((IF(Sheet!$A$2:$A$126=$A5,Sheet!$M$2:$M$126,0))))}

The answer should be 5.452 but it's coming back #DIV/0

Please help!!
 
K

kelljeff

I thought that too.
But, When I pull it out and tried it alone it is returning a 5 which i
correct.
Also, If I add, subtract and multiply it works... only when I divide i
returns the #DIV/0
 
Top