Spreadsheet: 795896d1662993814-need-a-way-to-increment-a-count-dependant-on-data-in-another-cell-roster-sample-fitz_69-
Sheet: Sheet1

 |  |  | 2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holidays |  | -1 | 1
 | TOIL | Site Spt Eng |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-03 00:00:00 |  | R | A
 |  | SSE 1 | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | HB |  |  | R | R | R | R | M |  |  | HB | B | B | B | B | B | B | B | B | B | B | HB |  |  | T | R | R | R | R |  |  | K | K | K | K | K | K | K | K | K | K | K | K | K | K | R |  |  |  | T | B
 |  | SSE 2 | R | R |  |  | F | A | A | A | A | A | A | A | A | A | A | HA |  |  | R | R | R | R | R |  |  | M | M | M | M | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HA
 |  | SSE 3 | A | A | A | A | F | R | R | R | M |  |  | K | K | K | K | K | K | K | K | K | K | K | K |  |  | R | R | R | R | HB | B | B | B | B | B | B | HB |  |  | R | F | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L |  |  |  |  | HB
 |  | SSE 4 | K | K | K | K | R | M | M | M | M |  |  | R | R | R | R | HA | A | A | A | A | A | A | A | A | A | HA | R | R | R | R | K | K | K | K | K | K | K | K | K | K | K | K | K | K |  |  | R | R | R | R | M |  |  | HA | A | A | A | A | A | A | A |  |  |  |  | K
 |  | SSE 5 | L | L | L | L | L | L | L | L | L | L | L | L | L | L | F | R |  |  | HB | B | B | B | B | B | B | HB | R | R | M | M |  |  | HA | A | A | A | A | A | A | A | A | A | A | A | A | A | HA | R | R | R | R |  |  | HB | B | B | B | B | B | B | B |  |  |  |  | M
 |  | SSE 6 | L | L | F | F | A | A | A | A | A | A | A | HA | R | R | R | HB | B | B | B | B | B | B | B | B | B | B | B | B | B | HB |  |  | R | R | R | R | M |  |  | K | K | K | K | K | K | K | K | K | K | K | K | K | K | R | R | R | R | M |  |  | HA
 |  | SSE 7 | B | B | B | B | B | B | B | B | F |  |  | R | R | R | R | R | K | K | K | K | K | K | K | K | K | K | K | K | K | K |  |  | R | R | R | R | M |  |  | HA | A | A | A | A | A | A | A | A | A | A | A | A | A | HA | R | R | R | R |  |  | HB
 |  | SSE 8 | R | R |  |  | K | K | K | K | K | K | K | R | R | M | M | HA | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | HA | R | R | R | R |  |  | HB | B | B | B | B | B | B | B | B | B | B | B | B | B | HB | R | R | R | R |  |  | K
 |  | SSE 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | -1 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | -1 | -1 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | -1
 | Weekday =0 If they contain A, B, HA, HB, K, L, M |  |  |  |  |  |  |  |  |  | Weekend/Holiday =1 If they contain A, B, HA, HB, K, M
 | Weekday =-1 If they contain R, T |  |  |  |  |  |  |  |  |  | Weekend/Holiday =0 If they are blank or contain L
 |  | SSE 1
 |  | SSE 2
 |  | SSE 3
 |  | SSE 4
 |  | SSE 5
 |  | SSE 6
 |  | SSE 7
 |  | SSE 8