Spreadsheet: 785641d1656520037-help-with-formula-sum-ifs-sumifshelp
Sheet: NEED HELP

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2
Week 1 |  |  |  |  | Type | Spare |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Platform |  |  |  |  | HIDDEN |  |  |  |  |  |  | HIDDEN
Sunday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  | Sunday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  |  |  |  | Non Platform |  |  |  |  |  |  | Non Platform
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  | O/T |  |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  | O/T |  |  |  |  |  |  |  | Platform |  |  |  |  |  |  | Platform
 |  |  |  |  |  |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]. |  |  |  | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru |  | Call Up |  |  |  |  |  |  |  | Plat OT |  |  |  |  |  |  | Plat OT
 | 0900 | 1000 |  |  | Stand-By |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By |  |  |  |  |  |  | Stand-By
 | 1000 | 2200 |  |  | Platform |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  | OT / Scrounge |  |  |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  | Pay Thru |  |  |  |  |  |  | Pay Thru
 |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  | DAY |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  | Sunday Premium |  |  |  |  |  |  |  |  |  |  |  |  | Sunday Premium |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  | Stat Worked
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1
Week 1 |  |  |  |  | Type | Booked |  | Platform | 12:00:00 |  |  |  | Week 2 |  |  |  |  |  |  |  | Platform |  |  |  |  | HIDDEN
Sunday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  | Sunday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  |  |  |  | Non Platform
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  | O/T | 0:00:00 |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  | O/T |  |  |  |  |  |  |  | Platform
 |  |  |  |  |  |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]. |  |  |  | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay | 12:00:00
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru |  | Call Up |  |  |  |  |  |  |  | Plat OT
 | 0900 | 1000 |  |  | Stand-By |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By
 | 1000 | 2200 |  |  | Platform |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  | Pay Thru
 |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  | Sunday Premium |  |  |  |  |  |  |  |  |  |  |  |  | Sunday Premium |  |  |  |  |  |  |  | Stat Worked
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total