if statements
 

Hello All,

I need help... Here is what I'm trying to do which might be completely
wrong but I'm trying.

I checked both if statement and they both work. So I don't know where I
am going wrong.

{=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)))) }

Any help would be great.
Thank you


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

if statements
 

What's wrong, i.e., what's the issue? Divide by zero errors?


"kelljeff" wrote:


Hello All,

I need help... Here is what I'm trying to do which might be completely
wrong but I'm trying.

I checked both if statement and they both work. So I don't know where I
am going wrong.

{=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)))) }

Any help would be great.
Thank you


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

if statements
 

I am getting #DIV/0... However if I do them individually it works. I
think the problem it with dividing the last if statement.
I'll break it out...
1402 70
{=SUM(((B5*(IF(Sheet!$A$2:$A$126=$A5,Sheet!$N$2:$N $126,0))/3600))/
5
((IF(Sheet!$A$2:$A$126=$A5,Sheet!$M$2:$M$126,0)))) } = 5.452

Sorry I did not explain it better previously


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