Dear Excel Experts,
I have a list of contractors, day, shift-wise movement i..e Performed TEUs and with using IF and SUMIFS I have to calculate Performed TEUs upon selection of..
Specific contractor or all contractors, from shift and to shift, Specific Shift or Both the Shifts Performed TEUs; it's done for all combinations excluding Both the shifts.
For example
Case 1
Contractor : Casby Logistics
From Date : 30-Apr-18
To Date : 02-May-18
Shift : Day
Performed TEUs : 5229
Case 2
Contractor : All TT Contractors
From Date : 30-Apr-18
To Date : 02-May-18
Shift : Night
Performed TEUs : 10459
Case 3
Contractor : Priti Logistics
From Date : 30-Apr-18
To Date : 02-May-18
Shift : Day
Performed TEUs : 5229
Case 4
Contractor : All TT Contractors
From Date : 30-Apr-18
To Date : 02-May-18
Shift : Both
Performed TEUs : 17390
As per formula in L2 cell, all combinations are working excluding Both Shifts., kindly help to resolve the same.
Thanks in advance.
Kravindra
Bookmarks