Spreadsheet: 266285d1379570100-sumif-formula-is-not-working-sumif-formula-not-working
Sheet: JOB LOCATION

Para | Line |  | Job Class | ASI1 | [NAME] | Position | REQ'D STR
100 | 1 |  | 15AO6 |  |  |  | 1
100 | 2 |  | 15AO5 |  |  |  | 1
100 | 3 |  | 99KE9 |  |  |  | 1
100 | 4 |  | 71AO5 |  |  |  | 1
100 | 5 |  | 71AO4 |  |  |  | 1
100 | 6 |  | 71AE8 |  |  |  | 1
100 | 7 |  | 91BO4 |  |  |  | 1
100 | 8 |  | 91BE7 |  |  |  | 1
100 | 9 |  | 51AO3 |  |  |  | 1
100 | 10 |  | 15AO4 |  |  |  | 1 |  |  | 15AO4 COUNT
100 | 11 |  | 15CO5 |  |  |  | 1
100 | 12 |  | 15CO4 |  |  |  | 1
100 | 13 |  | 15CO3 |  |  |  | 1
100 | 3 |  | 15AO4 |  |  |  | 0
101 | 1 |  | 51AO4 |  |  |  | 1
101 | 2 |  | 51AO2 |  |  |  | 1
101 | 3 |  | 51AE7 |  |  |  | 1
101 | 4 |  | 51DO3 |  |  |  | 1
101 | 5 |  | 51DE7 |  |  |  | 1
102 | 1 |  | 21FO5 |  |  |  | 1
102 | 2 |  | 21FO4 |  |  |  | 1
102 | 3 |  | 21FE6 |  |  |  | 5
102 | 8 |  | 21FO3 |  |  |  | 1
102 | 9 |  | 21CO3 |  |  |  | 1
102 | 10 |  | 21CE6 |  |  |  | 1
102 | 11 |  | 21FE5 |  |  |  | 5
102 | 16 |  | 21FE7 |  |  |  | 1
102 | 2 |  | 21AO3 |  |  |  | 0
102 | 3 |  | 21AE6 |  |  |  | 0
102 | 4 |  | 21CO3 |  |  |  | 0
102 | 5 |  | 21CE5 |  |  |  | 0
102 | 6 |  | 21AE5 |  |  |  | 0
103 | 1 |  | 81AO4 |  |  |  | 1
103 | 2 |  | 81AO3 |  |  |  | 1
103 | 3 |  | 85AE8 |  |  |  | 1
103 | 4 |  | 83AO3 |  |  |  | 1
103 | 5 |  | 86AE6 |  |  |  | 2
103 | 7 |  | [NAME] |  |  |  | 1
103 | 8 |  | [NAME] |  |  |  | 1
103 | 9 |  | 86AE6 |  |  |  | 2
103 | 11 |  | 85AE4 |  |  |  | 2
103 | 13 |  | 85AE4 |  |  |  | 1
103 | 14 |  | 86AO3 |  |  |  | 1
103 | 15 |  | 86AE6 |  |  |  | 2
103 | 17 |  | 86AE8 |  |  |  | 1
103 | 18 |  | 85AE6 |  |  |  | 1
103 | 19 |  | 86AE4 |  |  |  | 1
104 | 1 |  | 75AO4 |  |  |  | 1
104 | 2 |  | 75AO3 |  |  |  | 1
104 | 3 |  | 75AO2 |  |  |  | 1
104 | 4 |  | 75AE4 |  |  |  | 1
104 | 5 |  | 76AO3 |  |  |  | 3
105 | 1 |  | 53AO4 |  |  |  | 1
105 | 2 |  | 53AO3 |  |  |  | 1
105 | 3 |  | 53AE8 |  |  |  | 1
170 | 1 |  | 33AO4 |  |  |  | 1
170 | 2 |  | 33AO3 |  |  |  | 1
170 | 3 |  | 33AE8 |  |  |  | 1
171 | 1 |  | 33AO3 |  |  |  | 1
171 | 2 |  | 33AO2 |  |  |  | 1
171 | 3 |  | 33AE7 |  |  |  | 1
171 | 4 |  | 33AE5 |  |  |  | 4
171 | 5 |  | 33AE4 |  |  |  | 0
200 | 1 |  | 15AO5 |  |  |  | 1
200 | 2 |  | 15AO4 |  |  |  | 1
200 | 3 |  | 15AO4 |  |  |  | 1
200 | 4 |  | 15AO3 |  |  |  | 1
200 | 5 |  | 15AO2 |  |  |  | 1
200 | 6 |  | 15AO3 |  |  |  | 1
200 | 7 |  | 99BE8 |  |  |  | 1
201 | 1 |  | 15AO4 |  |  |  | 1
201 | 2 |  | 15AO4 |  |  |  | 2
201 | 3 |  | 15AO3 |  |  |  | 6
201 | 4 |  | 15AO2 |  |  |  | 4
201 | 5 |  | 15EO3 |  |  |  | 1
201 | 6 |  | 15EO3 |  |  |  | 2
201 | 7 |  | 15EO3 |  |  |  | 3
201 | 8 |  | 15EO2 |  |  |  | 3
201 | 9 |  | 15DE8 |  |  |  | 1
201 | 10 |  | 15DE7 |  |  |  | 3
201 | 11 |  | 15DE7 |  |  |  | 3
201 | 12 |  | 15DE6 |  |  |  | 5
201 | 13 |  | 15DE5 |  |  |  | 6
202 | 1 |  | 15HO4 |  |  |  | 1
202 | 2 |  | 15HO3 |  |  |  | 1
202 | 3 |  | 15HO2 |  |  |  | 1
202 | 4 |  | 15HE7 |  |  |  | 1
202 | 5 |  | 15HE4 |  |  |  | 2
202 | 5 |  | 15HE4 |  |  |  | 0
203 | 1 |  | 15GE7 |  |  |  | 1
203 | 2 |  | 15GE6 |  |  |  | 1
204 | 1 |  | 15AO4 |  |  |  | 1
204 | 2 |  | 99BO3 |  |  |  | 1
204 | 3 |  | 99BO2 |  |  |  | 1
204 | 4 |  | 99BE7 |  |  |  | 1
205 | 1 |  | 15MO4 |  |  |  | 1
205 | 2 |  | 15MO3 |  |  |  | 1
205 | 3 |  | 15ME7 |  |  |  | 1
205 | 4 |  | 15ME6 |  |  |  | 1
205 | 2 |  | 15MO2 |  |  |  | 0
206 | 1 |  | 15NO3 |  |  |  | 1
206 | 2 |  | 15NO2 |  |  |  | 1
206 | 3 |  | 15NE8 |  |  |  | 1
206 | 4 |  | 15NE7 |  |  |  | 2
207 | 1 |  | 15FO4 |  |  |  | 1
207 | 2 |  | 15FO3 |  |  |  | 1
207 | 3 |  | 15FE7 |  |  |  | 1
207 | 4 |  | 15FE6 |  |  |  | 1
207 | 5 |  | 15FE4 |  |  |  | 4
207 | 9 |  | 15FE6 |  |  |  | 1
207 | 10 |  | 15FE4 |  |  |  | 2
207 | 12 |  | 15FE8 |  |  |  | 2
300 | 1 |  | 15OO5 |  |  |  | 1
300 | 2 |  | 15OO4 |  |  |  | 1
300 | 3 |  | 15OE8 |  |  |  | 1
300 | 4 |  | 15OO3 |  |  |  | 1
301 | 1 |  | 15OO4 |  |  |  | 1
301 | 2 |  | 15OO3 |  |  |  | 1
301 | 3 |  | 15OO3 |  |  |  | 1
301 | 4 |  | 15OO3 |  |  |  | 1
301 | 5 |  | 15OO3 |  |  |  | 1
301 | 6 |  | 15OO3 |  |  |  | 1
301 | 7 |  | 15OO3 |  |  |  | 1
301 | 8 |  | 15OE6 |  |  |  | 1
301 | 9 |  | 15OO2 |  |  |  | 1
301 | 10 |  | 15OE5 |  |  |  | 1
301 | 1 |  | 15OO3 |  |  |  | 0
301 | 2 |  | 15OE7 |  |  |  | 0
301 | 3 |  | 15OE7 |  |  |  | 0
302 | 1 |  | 15OO2 |  |  |  | 0
302 | 2 |  | 15OE6 |  |  |  | 0
302 | 3 |  | 15OE7 |  |  |  | 0
302 | 4 |  | 15OE5 |  |  |  | 0
302 | 1 |  | 15OO4 |  |  |  | 1
302 | 2 |  | 15OO3 |  |  |  | 1
302 | 3 |  | 15OE8 |  |  |  | 1
302 | 4 |  | 15OE7 |  |  |  | 1
302 | 5 |  | 15OE6 |  |  |  | 3
302 | 8 |  | 15OE5 |  |  |  | 4
302 | 12 |  | 15OO3 |  |  |  | 1
302 | 13 |  | 15OO2 |  |  |  | 1
302 | 14 |  | 15OE7 |  |  |  | 1
302 | 15 |  | 15OE6 |  |  |  | 1
302 | 16 |  | 15OE5 |  |  |  | 2
302 | 18 |  | 15OO2 |  |  |  | 1
302 | 19 |  | 15OE7 |  |  |  | 1
302 | 20 |  | 15OE6 |  |  |  | 1
302 | 21 |  | 15OE5 |  |  |  | 2
303 | 2 |  | 15OO2 |  |  |  | 0
303 | 3 |  | 15OE4 |  |  |  | 0
303 | 4 |  | 15OE6 |  |  |  | 0
303 | 5 |  | 15OE4 |  |  |  | 0
303 | 6 |  | 15OE6 |  |  |  | 0
303 | 7 |  | 15OE4 |  |  |  | 0
303 | 8 |  | 15OE5 |  |  |  | 0
303 | 9 |  | 15OE5 |  |  |  | 0
303 | 10 |  | 15OE5 |  |  |  | 0
304 | 1 |  | 15OE6 |  |  |  | 0
304 | 2 |  | 15OE4 |  |  |  | 0
304 | 3 |  | 15OE5 |  |  |  | 0
304 | 4 |  | 15OE4 |  |  |  | 0
305 | 1 |  | 15OE6 |  |  |  | 0
305 | 2 |  | 15OE5 |  |  |  | 0
305 | 3 |  | 15OE6 |  |  |  | 0
305 | 4 |  | 15OE5 |  |  |  | 0
305 | 5 |  | 15OE6 |  |  |  | 0
305 | 6 |  | 15OE5 |  |  |  | 0
306 | 1 |  | 15OO2 |  |  |  | 0
306 | 2 |  | 15OE6 |  |  |  | 0
306 | 3 |  | 15OE4 |  |  |  | 0
307 | 1 |  | 15OO2 |  |  |  | 0
307 | 2 |  | 15OE7 |  |  |  | 0
307 | 3 |  | 15OE7 |  |  |  | 0
307 | 4 |  | 15OE6 |  |  |  | 0
307 | 5 |  | 15OE6 |  |  |  | 0
303 | 1 |  | 15OO3 |  |  |  | 1
303 | 2 |  | 15OO2 |  |  |  | 1
308 | 3 |  | 15OO2 |  |  |  | 0
303 | 3 |  | 15OE7 |  |  |  | 1
303 | 4 |  | 15OE4 |  |  |  | 1
303 | 5 |  | 15OO2 |  |  |  | 1
303 | 6 |  | 15OE7 |  |  |  | 1
303 | 7 |  | 15OE4 |  |  |  | 1
308 | 7 |  | 15OE6 |  |  |  | 0
308 | 8 |  | 15OE5 |  |  |  | 0
303 | 8 |  | 15OE7 |  |  |  | 1
303 | 9 |  | 15OE5 |  |  |  | 2
304 | 1 |  | 15OO3 |  |  |  | 1
304 | 2 |  | 15OE7 |  |  |  | 1
309 | 4 |  | 15OE7 |  |  |  | 0
304 | 3 |  | 15OE4 |  |  |  | 1
304 | 4 |  | 15OO2 |  |  |  | 1
304 | 5 |  | 15OE7 |  |  |  | 1
304 | 6 |  | 15OE6 |  |  |  | 1
309 | 7 |  | 15OE4 |  |  |  | 0
305 | 1 |  | 15OO3 |  |  |  | 1
305 | 2 |  | 15OO2 |  |  |  | 1
305 | 3 |  | 15OO2 |  |  |  | 1
305 | 4 |  | 15OE6 |  |  |  | 1
305 | 5 |  | 15OO2 |  |  |  | 1
305 | 6 |  | 15OE7 |  |  |  | 1
305 | 7 |  | 15OE6 |  |  |  | 2
305 | 9 |  | 15OE5 |  |  |  | 2
400 | 1 |  | 99BO5 |  |  |  | 1
400 | 2 |  | 99BO4 |  |  |  | 1
400 | 3 |  | 99BE8 |  |  |  | 1
400 | 4 |  | 33AE7 |  |  |  | 1
400 | 5 |  | 33AE7 |  |  |  | 2
401 | 1 |  | 69AO4 |  |  |  | 1
401 | 2 |  | 69AE7 |  |  |  | 1
401 | 3 |  | 61AE7 |  |  |  | 1
401 | 4 |  | 61AO2 |  |  |  | 1
401 | 5 |  | 61AE7 |  |  |  | 1
401 | 6 |  | 61AE6 |  |  |  | 1
401 | 7 |  | 61AE7 |  |  |  | 2
401 | 9 |  | 61AO4 |  |  |  | 1
401 | 10 |  | 69AO2 |  |  |  | 1
401 | 11 |  | 64AE4 |  |  |  | 2
401 | 13 |  | 65AE5 |  |  |  | 1
401 | 14 |  | 60AO3 |  |  |  | 1
401 | 15 |  | 60AO3 |  |  |  | 1
401 | 16 |  | 60AO2 |  |  |  | 1
401 | 17 |  | 60AO2 |  |  |  | 1
402 | 1 |  | 65AO2 |  |  |  | 1
402 | 2 |  | 65AE8 |  |  |  | 1
402 | 3 |  | 65AE6 |  |  |  | 1
402 | 4 |  | 65AE7 |  |  |  | 1
402 | 5 |  | 65AE6 |  |  |  | 1
402 | 6 |  | 65AE6 |  |  |  | 1
402 | 7 |  | 65AE4 |  |  |  | 1
402 | 8 |  | 65AE5 |  |  |  | 1
403 | 1 |  | 15PO4 |  |  |  | 1
403 | 2 |  | 15PO3 |  |  |  | 1 | 1
403 | 3 |  | 15PE8 |  |  |  | 2 | 2
403 | 5 |  | 15PE7 |  |  |  | 2 | 2
403 | 7 |  | 15PE6 |  |  |  | 10 | 10
403 | 17 |  | 15PE4 |  |  |  | 14 | 14
403 | 2 |  | 33AE6 |  |  |  | 0 | -1
403 | 3 |  | 33AE4 |  |  |  | 0 | -6
404 | 1 |  | 40AO3 |  |  |  | 1
404 | 2 |  | 40AO2 |  |  |  | 1
404 | 3 |  | 40AE7 |  |  |  | 1
404 | 4 |  | 41AE6 |  |  |  | 1
404 | 5 |  | 41AO2 |  |  |  | 1
404 | 6 |  | 41AE7 |  |  |  | 1
404 | 7 |  | 43AE6 |  |  |  | 1
404 | 8 |  | 43AE6 |  |  |  | 1
404 | 9 |  | 43AE6 |  |  |  | 1
500 | 1 |  | 90AO4 |  |  |  | 1
500 | 2 |  | 90AO3 |  |  |  | 1
500 | 3 |  | 90AE8 |  |  |  | 1 | 1
500 | 3 |  | 90AE8 |  |  |  | 0 | -1
500 | 4 |  | 90AE5 |  |  |  | 1
500 | 5 |  | 90AE7 |  |  |  | 1 | 1
500 | 6 |  | 90AE6 |  |  |  | 1 | 1
500 | 5 |  | 90AE7 |  |  |  | 0 | -1
500 | 6 |  | 90AE5 |  |  |  | 0 | -1
501 | 1 |  | 91AO2 |  |  |  | 1
501 | 2 |  | 91AE7 |  |  |  | 1
501 | 3 |  | 91AE4 |  |  |  | 2
502 | 1 |  | 91AO3 |  |  |  | 1
502 | 2 |  | 91AO2 |  |  |  | 1
502 | 3 |  | 91AE7 |  |  |  | 1
502 | 4 |  | 91AE6 |  |  |  | 3
502 | 5 |  | 91AE5 |  |  |  | 3
502 | 6 |  | 91AE4 |  |  |  | 41
503 | 1 |  | 91AO3 |  |  |  | 1
503 | 2 |  | 91AO2 |  |  |  | 1
503 | 3 |  | 91AE7 |  |  |  | 1
503 | 4 |  | 91AE6 |  |  |  | 3
503 | 5 |  | 91AE5 |  |  |  | 3
503 | 6 |  | 91AE4 |  |  |  | 40
504 | 1 |  | 91AO2 |  |  |  | 1
504 | 2 |  | 91AE7 |  |  |  | 1
504 | 3 |  | 91AE6 |  |  |  | 3
504 | 4 |  | 91AE5 |  |  |  | 3
502 | 3 |  | 91AE5 |  |  |  | 0
502 | 4 |  | 91AE6 |  |  |  | 0
504 | 5 |  | 91AE4 |  |  |  | 27
504 | 5 |  | 91AE4 |  |  |  | 0