Formula issue
 

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


--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=529184

Formula issue
 

your second if statement is returning a zero


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=529184

Formula issue
 

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


--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=529184

Formula issue
 

Any suggestions on a different formula


--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=529184