Spreadsheet: 746740d1630994162-sumifs-with-table-references-results-in-value-error-exceld-and-c
Sheet: Staff List

D/C | Role | Capacity Type | Status | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22
D | BA | BAU | ACTIVE | 8 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 9 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
D | BA | OTHPROJ | ACTIVE
D | BA | DTP | ACTIVE
C | BA | BAU | ACTIVE |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 0.5
C | BA | BAU | ACTIVE |  |  |  |  |  |  |  |  | 0.87 | 0.87 | 0.87 | 0.87 | 0.87 | 0.87 | 0.87 | 0.87 | 0.87 | 0.87 | 0.87 | 0.87 | 0.87
C | BA | OTHPROJ | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 0.9 | 0.9
C | BA | BAU | ACTIVE | 1 | 1 | 0.5 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE |  |  | 0.5 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE |  |  |  | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE | 1 | 1 | 1 | 0.5 | 0.5
C | BA | BAU | ACTIVE |  |  |  | 0.5 |  | 0.5 | 0.5 | 0.5 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE | 1 | 1 | 1 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  |  | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAP | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE
C | BA | BAP | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE |  |  |  | 1 | 1
C | BA | BAU | ACTIVE | 0.7 | 0.7 | 0.3 |  |  |  |  |  |  |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE | 1 |  |  | 1 | 1 | 1 | 1 | 1
C | BA | BAU | ACTIVE | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | ACTIVE | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
C | BA | BAP | INACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | INACTIVE | 1 |  |  |  |  |  | 0.5 | 1 | 1 | 1 | 1
C | BA | OTHPROJ | INACTIVE |  | 1 | 1 | 1 | 1 | 1 | 0.5
C | BA | BAU | INACTIVE | 0.6 | 0.6 | 1 | 1 | 1 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6
C | BA | BAP | INACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
C | BA | BAU | INACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
C | BA | OTHPROJ | INACTIVE | 1
C | BA | BAU | INACTIVE | 1 | 1
C | BA | BAU | INACTIVE |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | BA | BAU | INACTIVE | 0.5 | 1 | 1 | 1 | 1
D | DEV | BAU | ACTIVE | 6 | 6 | 5 | 5 | 5 | 5 | 8 | 8 | 8 | 8 | 8 | 8 | 10 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
D | DEV | OTHPROJ | ACTIVE
D | DEV | DTP | ACTIVE
C | DEV | DTP | ACTIVE |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE | 0.9 | 0.9 | 0.5 |  |  |  | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | ACTIVE | 0.1 | 0.1 | 0.5 | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE | 0.5 | 0.5 | 0.5
C | DEV | DTP | ACTIVE | 0.5 | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | ACTIVE | 1 | 1 | 1 | 0.5 | 0.5 |  |  |  |  |  |  |  |  |  | 0.5 | 0.5
C | DEV | BAU | ACTIVE |  |  |  | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE |  | 0.25 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7
C | DEV | OTHPROJ | ACTIVE | 0.5 | 0.25
C | DEV | DTP | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 0.5 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8 | 0.8
C | DEV | OTHPROJ | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2
C | DEV | BAU | ACTIVE |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | ACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | ACTIVE |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | DTP | ACTIVE |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | INACTIVE | 1 | 1 | 1 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | INACTIVE |  |  |  | 0.5
C | DEV | BAU | INACTIVE |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | INACTIVE
C | DEV | OTHPROJ | INACTIVE | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | INACTIVE |  |  |  |  |  |  |  |  |  |  | 1
C | DEV | OTHPROJ | INACTIVE |  |  |  |  |  |  |  |  |  |  | 1
C | DEV | BAU | INACTIVE | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | INACTIVE |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | OTHPROJ | INACTIVE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
C | DEV | BAU | INACTIVE |  |  |  |  |  | 0.5
C | DEV | OTHPROJ | INACTIVE |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5