Spreadsheet: 728329d1618410594-sumif-across-multiple-columns-example
Sheet: Work Calendar

 | Week Of: | 2021-04-12 00:00:00 | 2021-04-12 00:00:00 | 2021-04-12 00:00:00 | 2021-04-12 00:00:00 | 2021-04-12 00:00:00 | 2021-04-12 00:00:00 | 2021-04-12 00:00:00 | 2021-04-19 00:00:00 | 2021-04-19 00:00:00 | 2021-04-19 00:00:00 | 2021-04-19 00:00:00 | 2021-04-19 00:00:00 | 2021-04-19 00:00:00 | 2021-04-19 00:00:00 | 2021-04-26 00:00:00 | 2021-04-26 00:00:00 | 2021-04-26 00:00:00 | 2021-04-26 00:00:00 | 2021-04-26 00:00:00 | 2021-04-26 00:00:00 | 2021-04-26 00:00:00 | 2021-05-03 00:00:00 | 2021-05-03 00:00:00 | 2021-05-03 00:00:00 | 2021-05-03 00:00:00 | 2021-05-03 00:00:00 | 2021-05-03 00:00:00 | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-10 00:00:00 | 2021-05-10 00:00:00 | 2021-05-10 00:00:00 | 2021-05-10 00:00:00 | 2021-05-10 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-17 00:00:00 | 2021-05-17 00:00:00 | 2021-05-17 00:00:00 | 2021-05-17 00:00:00 | 2021-05-17 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-24 00:00:00 | 2021-05-24 00:00:00 | 2021-05-24 00:00:00 | 2021-05-24 00:00:00 | 2021-05-24 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-05-31 00:00:00 | 2021-05-31 00:00:00 | 2021-05-31 00:00:00 | 2021-05-31 00:00:00 | 2021-05-31 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-07 00:00:00 | 2021-06-07 00:00:00 | 2021-06-07 00:00:00 | 2021-06-07 00:00:00 | 2021-06-07 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-14 00:00:00 | 2021-06-14 00:00:00 | 2021-06-14 00:00:00 | 2021-06-14 00:00:00 | 2021-06-14 00:00:00 | 2021-06-14 00:00:00
Project | Resource Name | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN | M | T | W | TH | FR | SAT | SUN
Project 1 | [NAME] | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
Project 1 | [NAME] | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
Project 2 | [NAME] | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  |  | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
Project 3 | [NAME] | 8
Project 5 | [NAME]
Project 5 | [NAME]
Project 5 | [NAME]
Project 5 | [NAME]
Project 6 | [NAME] | 3 | 3 | 3 | 3 | 6 |  |  | 3 | 3 | 3 | 3 | 6 |  |  | 3 | 3 | 3 | 3 | 6 |  |  | 3 | 3 | 3 | 3 | 6 |  |  | 3 | 3 | 3 | 3 | 6 |  |  | 3 | 3 | 3 | 3 | 6 |  |  | 3 | 3 | 3 | 3 | 6 |  |  |  | 6 | 3 | 3 | 6 |  |  | 3 | 3 | 3 | 3 | 6 |  |  | 3 | 3 | 3 | 3 | 6
Project 6 | [NAME] | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
Project 6 | Derek | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
Project 6 | [NAME] | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
Project 6 | Sean | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  |  | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
Project 6 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  |  | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
Project 6 | Trent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  |  | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
Project 6 | [NAME] | 8 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 4 | 4 | 4 | 4 | 4
Project 6 | [NAME] | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  |  | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3 |  |  | 3 | 3 | 3 | 3 | 3
Project 6 | [NAME] | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Project 6 | Hank | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Project 6 | [NAME]
Project 7 | [NAME] |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 12 |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
Project 7 | [NAME] | 8 | 8 | 5.5 | 6 | 5 |  |  | 8 | 8 | 8 | 8 | 5.5 |  |  | 8 | 8 | 8 | 8 | 5.5 |  |  | 8 | 8 | 8 | 8 | 5.5 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 5.5 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 2 | 4.5 |  |  |  | 8 | 8 | 8 | 8 | 5.5
Project 7 | [NAME] | 8 | 8 | 8 | 8 | 8 |  |  | 4 | 4 | 4 | 4
Project 7 | [NAME] | 8 | 8 | 8 | 8 | 8 |  |  | 4 | 4
Project 7 | [NAME] |  | 1 |  |  |  |  |  | 0.5 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Project 7 | [NAME] |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.5
Project 7 | Hank |  | 2 | 2 | 2 | 2 |  |  |  | 2 | 2 | 2 | 2 |  |  |  | 3 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 2