Spreadsheet: 785641d1656520037-help-with-formula-sum-ifs-sumifshelp
Sheet: May 8 - 21

Total | Platform | Non Plat | O/T | [NAME]. | Call Up | Stat Day |  | Stat Worked | Vacation | Legislative Paid | Sunday Premium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2
Week 1 |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By |  |  |  |  |  |  | Stand-By
 |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Platform |  |  |  |  | HIDDEN |  |  |  |  |  |  | HIDDEN
Monday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  | Monday |  |  |  |  | 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
 |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By |  |  |  |  |  |  | Stand-By
 |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  | OT / Scrounge |  |  |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  | Pay Thru |  |  |  |  |  |  | Pay Thru
 |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  | DAY |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Platform |  |  |  |  | HIDDEN |  |  |  |  |  |  | HIDDEN
Tuesday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  | Tuesday |  |  |  |  | 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
 |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By |  |  |  |  |  |  | Stand-By
 |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  | OT / Scrounge |  |  |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  | Pay Thru |  |  |  |  |  |  | Pay Thru
 |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  | DAY |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Platform |  |  |  |  | HIDDEN |  |  |  |  |  |  | HIDDEN
Wednesday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  | Wednesday |  |  |  |  | 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
 |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By |  |  |  |  |  |  | Stand-By
 |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  | OT / Scrounge |  |  |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  | Pay Thru |  |  |  |  |  |  | Pay Thru
 |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  | DAY |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Platform |  |  |  |  | HIDDEN |  |  |  |  |  |  | HIDDEN
Thursday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  | Thursday |  |  |  |  | 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
 |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By |  |  |  |  |  |  | Stand-By
 |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  | OT / Scrounge |  |  |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  | Pay Thru |  |  |  |  |  |  | Pay Thru
 |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  | DAY |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Platform |  |  |  |  | HIDDEN |  |  |  |  |  |  | HIDDEN
Friday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  | Friday |  |  |  |  | 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
 |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By |  |  |  |  |  |  | Stand-By
 |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  | OT / Scrounge |  |  |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  | Pay Thru |  |  |  |  |  |  | Pay Thru
 |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  | DAY |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  | Platform |  |  |  |  | HIDDEN |  |  |  |  |  |  | HIDDEN
Saturday |  |  |  |  | HOS |  |  | Non Plat |  |  |  |  | Saturday |  |  |  |  | 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
 |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  | Stat Day |  |  |  |  |  |  |  | Stand-By |  |  |  |  |  |  | Stand-By
 |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  | OT / Scrounge |  |  |  |  |  |  | OT / Scrounge
 |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  |  |  |  |  | Pay Thru |  |  |  |  |  |  | Pay Thru
 |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  | Legislative Paid |  |  |  |  |  |  |  | DAY |  |  |  |  |  |  | DAY
 |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  | Stat Worked