if statements

K

kelljeff

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
 
K

kelljeff

I am getting #DIV/0... However if I do them individually it works.
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 previousl
 
Top