Thread: if statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kelljeff
 
Posts: n/a
Default 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