Spreadsheet: 689640d1596566367-require-a-help-on-sumif-function-for-multiple-range-sheet-2
Sheet: Sheet1

 | JAN |  |  | FEB |  |  | CRITERIA
 | Details | Total |  | Details | Total |  |  | GRAND TOTAL
 | CBB HRS |  |  | CBB  HRS | 69 |  | CBB  HRS
 | CBB OT | 2 |  | CBB  OT | 8 |  | CBB  OT
 | JO /20/115 HRS |  |  | JO/17/142 HRS | 78 |  | JO/17/142 HRS
 | JO /20/115 OT | 2 |  | JO/17/142 OT | 8 |  | JO/17/142 OT
 | JO /20/120 HRS | 8 |  | JO/18/167-R HRS | 4 |  | JO/18/167-R HRS
 | JO /20/120 OT | 3.5 |  | JO/18/167-R OT |  |  | JO/18/167-R OT
 | JO /20/135 HRS | 8 |  | JO/19/202 HRS | 36.5 |  | JO/19/202 HRS
 | JO /20/135 OT |  |  | JO/19/202 OT |  |  | JO/19/202 OT
 | JO /20/137 HRS | 8 |  | JO/19/207 HRS | 4 |  | JO/19/207 HRS
 | JO /20/137 OT |  |  | JO/19/207 OT |  |  | JO/19/207 OT
 | JO /20/139 HRS | 8 |  | JO/19/209 HRS | 19.5 |  | JO/19/209 HRS
 | JO /20/139 OT |  |  | JO/19/209 OT |  |  | JO/19/209 OT
 | JO /20/149 HRS | 12 |  | JO/19/221 HRS | 28 |  | JO/19/221 HRS
 | JO /20/149 OT |  |  | JO/19/221 OT |  |  | JO/19/221 OT
 | JO /20/153 HRS | 12 |  | [NAME] | 13 |  | [NAME]
 | JO /20/153 OT |  |  | [NAME] | 12 |  | [NAME]
 | JO /20/171 HRS | 14 |  | [NAME] | 40 |  | [NAME]
 | JO /20/171 OT |  |  | JO/19/249 OT | 6.3 |  | JO/19/249 OT
 | JO /20/174 HRS | 8.5 |  | JO/19/252 HRS | 248 |  | JO/19/252 HRS
 | JO /20/174 OT | 2.5 |  | [NAME] |  |  | [NAME]
 | JO/19/201 HRS |  |  | JO/20/036 HRS | 8 |  | JO/20/036 HRS
 | JO/19/201 OT |  |  | JO/20/036 OT |  |  | JO/20/036 OT
 | JO/19/221 HRS | 60 |  | JO/20/058 HRS | 10 |  | JO/20/058 HRS
 | JO/19/221 OT |  |  | JO/20/058 OT |  |  | JO/20/058 OT
 | [NAME] | 24 |  | JO/20/083 HRS | 41 |  | JO/20/083 HRS
 | [NAME] |  |  | JO/20/083 OT | 1 |  | JO/20/083 OT
 | JO/20/083 HRS | 18 |  | [NAME] | 213 |  | [NAME]
 | JO/20/083 OT |  |  | [NAME] | 14.6 |  | [NAME]
 | [NAME] | 8 |  | JO/20/096 HRS | 34 |  | JO/20/096 HRS
 | JO/20/089 OT |  |  | JO/20/096 OT |  |  | JO/20/096 OT
 | [NAME] |  |  | [NAME] | 187 |  | [NAME]
 | [NAME] | 1.3 |  | [NAME] | 2.3 |  | [NAME]
 | [NAME] | 231 |  | JO/20/120 HRS |  |  | JO/20/120 HRS
 | [NAME] | 28.6 |  | JO/20/120 OT | 4 |  | JO/20/120 OT
 | JO/20/117 HRS | 16 |  | JO/20/120-B HRS | 109 |  | JO/20/120-B HRS
 | JO/20/117 OT |  |  | JO/20/120-B OT | 30.5 |  | JO/20/120-B OT
 | [NAME] | 578 |  | [NAME] | 49 |  | [NAME]
 | [NAME] | 24 |  | [NAME] |  |  | [NAME]
 | JO/20/120 HRS | 222 |  | JO/20/135 HRS | 130.5 |  | JO/20/135 HRS
 | JO/20/120 OT | 40 |  | JO/20/135 OT | 16 |  | JO/20/135 OT
 | JO/20/135 HRS | 138 |  | JO/20/137 HRS | 86 |  | JO/20/137 HRS
 | JO/20/135 OT | 2 |  | [NAME] | 12 |  | [NAME]
 | JO/20/137 HRS | 248 |  | JO/20/139 HRS | 124.3 |  | JO/20/139 HRS
 | [NAME] |  |  | JO/20/139 OT | 41.90000000000001 |  | JO/20/139 OT
 | JO/20/139 HRS | 259 |  | JO/20/142 HRS | 86 |  | JO/20/142 HRS
 | JO/20/139 OT |  |  | JO/20/142 OT | 14 |  | JO/20/142 OT
 | JO/20/142 HRS | 261 |  | JO/20/144 HRS | 493 |  | JO/20/144 HRS
 | JO/20/142 OT | 8 |  | JO/20/144 OT | 10 |  | JO/20/144 OT
 | JO/20/144 HRS | 463.5 |  | JO/20/149 HRS | 19 |  | JO/20/149 HRS
 | JO/20/144 OT | 180.1 |  | JO/20/149 OT |  |  | JO/20/149 OT
 | JO/20/146 HRS | 24 |  | JO/20/153 HRS | 54 |  | JO/20/153 HRS
 | JO/20/146 OT |  |  | JO/20/153 OT | 34 |  | JO/20/153 OT
 | [NAME] | 104 |  | JO/20/162 HRS | 60 |  | JO/20/162 HRS
 | [NAME] | 6 |  | [NAME] |  |  | [NAME]
 | JO/20/148 HRS | 17 |  | JO/20/164  HRS | 16 |  | JO/20/164  HRS
 | JO/20/148 OT |  |  | JO/20/164  OT |  |  | JO/20/164  OT
 | JO/20/149 HRS | 63 |  | JO/20/164 HRS | 30 |  | JO/20/164 HRS
 | JO/20/149 OT | 19 |  | JO/20/164 OT |  |  | JO/20/164 OT
 | JO/20/150 HRS | 34 |  | JO/20/175 HRS | 10 |  | JO/20/175 HRS
 | JO/20/150 OT |  |  | JO/20/175 OT | 4.6 |  | JO/20/175 OT
 | JO/20/151 HRS | 97 |  | JO/20/178 HRS | 238.5 |  | JO/20/178 HRS
 | JO/20/151 OT | 6.5 |  | JO/20/178 OT | 46.2 |  | JO/20/178 OT
 | JO/20/152 HRS | 39 |  | JO/20/179 HRS |  |  | JO/20/179 HRS
 | JO/20/152 OT |  |  | JO/20/179 OT | 12 |  | JO/20/179 OT
 | JO/20/153 HRS | 76 |  | [NAME] | 14 |  | [NAME]
 | JO/20/153 OT | 3 |  | JO/20/180 OT |  |  | JO/20/180 OT
 | JO/20/154 HRS | 64 |  | [NAME] | 256 |  | [NAME]
 | JO/20/154 OT |  |  | [NAME] | 9 |  | [NAME]
 | JO/20/155 HRS | 139 |  | JO/20/182 HRS | 18 |  | JO/20/182 HRS
 | JO/20/155 OT |  |  | JO/20/182 OT |  |  | JO/20/182 OT
 | JO/20/156 HRS | 162 |  | JO/20/183 HRS |  |  | JO/20/183 HRS
 | JO/20/156 OT | 19.5 |  | JO/20/183 OT | 1 |  | JO/20/183 OT
 | JO/20/162 HRS | 51 |  | [NAME] | 36 |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] | 24 |  | JO/20/185 HRS | 231 |  | JO/20/185 HRS
 | [NAME] |  |  | JO/20/185 OT |  |  | JO/20/185 OT
 | [NAME] | 101 |  | JO/20/186 HRS | 195 |  | JO/20/186 HRS
 | [NAME] |  |  | JO/20/186 OT | 27 |  | JO/20/186 OT
 | JO/20/167 HRS | 24 |  | JO/20/188 HRS | 164.3 |  | JO/20/188 HRS
 | JO/20/167 OT |  |  | JO/20/188 OT | 6 |  | JO/20/188 OT
 | JO/20/168 HRS | 36 |  | [NAME] | 100 |  | [NAME]
 | JO/20/168 OT |  |  | JO/20/189 OT |  |  | JO/20/189 OT
 | JO/20/169 HRS | 3 |  | [NAME] | 14 |  | [NAME]
 | JO/20/169 OT | 2 |  | [NAME] | 7.5 |  | [NAME]
 | JO/20/170 HRS | 30 |  | JO/20/191 HRS | 67 |  | JO/20/191 HRS
 | JO/20/170 OT |  |  | JO/20/191 OT |  |  | JO/20/191 OT
 | JO/20/173 HRS | 4 |  | JO/20/192 HRS | 4 |  | JO/20/192 HRS
 | JO/20/173 OT |  |  | JO/20/192 OT | 6 |  | JO/20/192 OT
 | [NAME] | 22 |  | JO/20/193 HRS | 154.5 |  | JO/20/193 HRS
 | [NAME] | 8 |  | JO/20/193 OT |  |  | JO/20/193 OT
 | JO/20/175 HRS | 12 |  | [NAME] | 54 |  | [NAME]
 | JO/20/175 OT |  |  | [NAME] |  |  | [NAME]
 | JO/20/178 HRS | 1 |  | JO/20/195 HRS | 6 |  | JO/20/195 HRS
 | JO/20/178 OT |  |  | JO/20/195 OT |  |  | JO/20/195 OT
 | JO/20/179  HRS | 24 |  | [NAME] | 6 |  | [NAME]
 | JO/20/179  OT | 6.6 |  | [NAME] |  |  | [NAME]
 | JO/20/179 HRS | 82 |  | JO/20/197 HRS | 1 |  | JO/20/197 HRS
 | JO/20/179 OT | 29.5 |  | JO/20/197 OT |  |  | JO/20/197 OT
 | [NAME] | 34 |  | [NAME] | 32 |  | [NAME]
 | JO/20/180 OT | 15 |  | [NAME] |  |  | [NAME]
 | JO/20/182 HRS | 68 |  | [NAME] | 72 |  | JO/20/210 HRS
 | JO/20/182 OT | 8 |  | [NAME] | 102.6 |  | JO/20/210 OT
 | JO/20/183 HRS | 8 |  | JO/20/202 HRS | 3 |  | JO/20/211 HRS
 | JO/20/183 OT |  |  | JO/20/202 OT |  |  | JO/20/211 OT
 | JO/20/210 HRS |  |  | JO/20/205 HRS | 2 |  | Maintainance / Other works  HRS
 | JO/20/210 OT |  |  | JO/20/205 OT |  |  | Maintainance / Other works  OT
 | JO/20/221 HRS | 3 |  | JO/20/206 HRS | 107
 | JO/20/221 OT |  |  | JO/20/206 OT | 5.6
 | JO/20/82 HRS | 6 |  | JO/20/208 HRS | 4
 | JO/20/82 OT |  |  | JO/20/208 OT
 | Maintainance / Other works  HRS | 4 |  | JO/20/210 HRS | 89
 | Maintainance / Other works  OT |  |  | JO/20/210 OT | 8.6
 |  |  |  | JO/20/211 HRS | 5
 |  |  |  | JO/20/211 OT
 |  |  |  | Maintainance / Other works  HRS | 111
 |  |  |  | Maintainance / Other works  OT | 10