sum time total time reported today per production line

Jon Brown

I have sheet that is being populated by data being entered into a form.

I have columns for "Date" "Production Line (text field)" and "Stoppage Length (time)"

I am trying to come up with a formula that enables me to sum the total stoppage length each day per production line.

I created a formula that uses the sumif formula to look at the whole date column and when the date equals today and the line equals "X" sum the related minutes column. I cant seem to get it to work though.

Assistance from a formula guru would be much appreciated.

Thanks

Jon

 

 

 

Brandy S. PVD

I created a test sheet and made a formula to return the total minutes a machine was stopped on today's date.  

 

=SUMIFS([Stoppage Length]:[Stoppage Length], [Production Line]:[Production Line], "Elopak", Date:Date, DAY(@cell) = DAY(TODAY()))

Jon Brown

Thanks Brandy,

That was 100% what I was looking for. 

 Your awesome!!

 

Brandy S. PVD

Yay! Happy I could help!