Spreadsheet: 713915d1611004308-sumif-error-help-book2
Sheet: Project 1 (2)

 | Project: | PROJECT 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES
 | Address: |  |  |  |  |  |  |  |  | TITLE:
 | Project No. |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: |  | Rev01 | Date: |  | 2021-12-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Issue: |  | 1 | Period: |  | 2021-01-01 00:00:00
 | 2021-01-01 00:00:00 |  |  | PERSON 1 |  |  | PERSON 2 |  |  | PERSON 3 |  |  | PERSON 4 |  |  | PERSON 5 |  |  | PERSON 6 |  |  | PERSON 7 |  |  | PERSON 8 |  |  | PERSON 9 |  |  | PERSON 10 |  |  |  | Daily Total
 |  |  |  | Description | Code | Hours | Description | Code | Hours | Description | Code | Hours | Description | Code | Hours | Description | Code | Hours | Description | Code | Hours | Description | Code | Hours | Description | Code | Hours | Description | Code | Hours | Description | Code | Hours
 | 1 |  |  | Boxing | 301 | 8 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 2 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 3 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 4 |  |  | Digging | 302 | 7 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 5 |  |  | Cladding | 303 | 8.5 |  |  | 0 | Digging | 302 | 7 |  |  | 0 |  |  | 0 |  |  | 0 | Cladding | 303 | 8.5 |  |  | 0 |  |  | 0 | Boxing | 301 | 8
 | 6 |  |  | External works | 304 | 9 |  |  | 0 | Cladding | 303 | 8.5 |  |  | 0 |  |  | 0 |  |  | 0 | External works | 304 | 9 |  |  | 0 |  |  | 0 | Boxing | 301 | 8
 | 7 |  |  | Cleaning | 305 | 10 | Digging | 302 | 7 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 8 |  |  | [NAME] | 306 | 9 | Cladding | 303 | 8.5 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 9 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 10 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 11 |  |  | Boxing | 301 | 4 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 12 |  |  | Nail cladding | 303 | 2 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | External works | 304 | 9 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 13 |  |  | 0 | 0 | 0 |  |  | 0 | Boxing | 301 | 4 |  |  | 0 |  |  | 0 | Cleaning | 305 | 10 |  |  | 0 |  |  | 0 | Boxing | 301 | 8 |  |  | 0
 | 14 |  |  | 0 | 0 | 0 |  |  | 0 | Nail cladding | 303 | 2 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 15 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 16 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 17 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 18 |  |  | 0 | 0 | 0 | Boxing | 301 | 4 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 19 |  |  | 0 | 0 | 0 | Nail cladding | 303 | 2 |  |  | 0 | External works | 304 | 9 |  |  | 0 |  |  | 0 |  |  | 0 | Cladding | 303 | 8.5 |  |  | 0 |  |  | 0
 | 20 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 | Cleaning | 305 | 10 |  |  | 0 |  |  | 0 |  |  | 0 | External works | 304 | 9 |  |  | 0 |  |  | 0
 | 21 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 22 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 23 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 24 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 25 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 26 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 27 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 28 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 29 |  |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 30 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | 31 | Weekend |  | 0 | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | total PERSON 1 |  |  | total PERSON 2 |  |  | total PERSON 3 |  |  | total PERSON 4 |  |  | total PERSON 5 |  |  | total PERSON 6 |  |  | total PERSON 7 |  |  | total PERSON 8 |  |  | total PERSON 9 |  |  | total PERSON 10