Spreadsheet: 785641d1656520037-help-with-formula-sum-ifs-sumifshelp
Sheet: Blank Temp DO NOT USE

Total | Platform | Non Plat | O/T | [NAME]. | Call Up | Stat Day |  |  |  |  |  |  |  | Stat Worked | Vacation | Legislative Paid
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform
Sunday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat |  |  |  |  | Sunday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T |  |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T
 |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME].
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up
 |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day
 |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked
 |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid
 |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform
Monday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat |  |  |  |  | Monday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T |  |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T
 |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME].
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up
 |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day
 |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked
 |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid
 |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform
Tuesday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat |  |  |  |  | Tuesday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T |  |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T
 |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME].
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up
 |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day
 |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked
 |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid
 |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform
Wednesday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat |  |  |  |  | Wednesday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T |  |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T
 |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME].
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up
 |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day
 |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked
 |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid
 |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform
Thursday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat |  |  |  |  | Thursday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T |  |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T
 |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME].
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up
 |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day
 |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked
 |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid
 |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform
Friday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat |  |  |  |  | Friday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T |  |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T
 |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME].
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up
 |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day
 |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked
 |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid
 |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform
Saturday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat |  |  |  |  | Saturday |  |  |  |  |  |  |  | HIDDEN |  |  |  |  |  | Non Plat
Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T |  |  |  |  | Special | Call Up ? | 09:30:00 | Hours | Decimal | Est. Earnings |  |  |  |  |  | Non Platform |  |  | O/T
 |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platform |  |  | [NAME].
Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up |  |  |  |  | Run # | Start Time | End Time | Extend | Duration | Task | Pay Thru | Hidden | Hidden | Hidden | Pay Thru | Plat Reg Pay |  |  | Call Up
 |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plat OT |  |  | Stat Day
 |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stand-By |  |  | Stat Worked
 |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT / Scrounge |  |  | Vacation
 |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Thru |  |  | Legislative Paid
 |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY |  |  | Total
 |  |  |  |  |  |  |  |  |  |  | Stat Worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stat Worked