software

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: www.excelforum.com/member.php...oamp;userid=32007
View this thread: www.excelforum.com/showthread...hreadid=529346What's wrong, i.e., what's the issue? Divide by zero errors?quot;kelljeffquot; wrote:

gt;
gt; Hello All,
gt;
gt; I need help... Here is what I'm trying to do which might be completely
gt; wrong but I'm trying.
gt;
gt; I checked both if statement and they both work. So I don't know where I
gt; am going wrong.
gt;
gt; {=SUM(((B5*(IF(Sheet!$A$2:$A$126=$A5,Sheet!$N$2:$N
gt; $126,0))/3600))/((IF(Sheet!$A$2:$A$126=$A5,Sheet!$M$2:$M$126,0)))) }
gt;
gt; Any help would be great.
gt; Thank you
gt;
gt;
gt; --
gt; kelljeff
gt; ------------------------------------------------------------------------
gt; kelljeff's Profile: www.excelforum.com/member.php...oamp;userid=32007
gt; View this thread: www.excelforum.com/showthread...hreadid=529346
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=32007
View this thread: www.excelforum.com/showthread...hreadid=529346