I am trying to sum up the daily total of LineDown time for work, based on what line it is. I have data that lists the day, the line, the cause, and the duration. I am trying to conditionally sum values saying if it is 9/15/14, or any other day, I want all the duration of all the Machine Cause of "LineDown" for Line "L05 Cracks"
=IF(INT(Data!H$2:$H$4500)=Sheet1!$B2*(MOD(Data!$H$2:$H$4500,1)>=0/24.2)*(MOD(Data!$H$2:$H$4500,1)<23.999/24.2),SUM(SUMIFS(Data!$I:$I,Data!$C:$C,"L05 Cracks",Data!$D:$D,"LineDown")),)
I tried this formula, but it only reads that the If statement is false. Any help on getting it to where I can set the time frame, would be much appreciated. The excel sheet has information in Sheet1 and Datadaily-downtime-september-january.xlsx
Bookmarks