Spreadsheet: 767519d1644505630-using-vlookup-but-would-prefer-index-match-match-w-sumifs-or-sumproduct-truck-file
Sheet: Sheet2

 |  |  |  |  |  | 2022 BUDGET
Cat | Type | 2022-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total | Branch |  | 2022-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total
COUNT | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
COUNT | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
COUNT | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
COUNT | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
COUNT | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
COUNT | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
COUNT | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 31
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 31
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 31
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 31
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 31
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 31
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 31
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 17
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 17
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 17
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 17
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 17
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 17
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 17
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 59
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 59
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 59
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 59
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 59
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 59
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 59
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 73
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 73
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 73
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 73
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 73
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 73
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 73
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 87
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 87
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 87
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 87
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 87
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 87
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 87
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 101
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 101
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 101
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 101
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 101
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 101
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 101
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 129
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 129
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 129
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 129
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 129
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 129
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 129
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 115
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 115
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 115
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 115
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 115
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 115
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 115
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 157
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 157
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 157
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 157
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 157
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 157
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 157
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 213
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 213
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 213
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 213
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 213
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 213
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 213
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 227
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 227
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 227
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 227
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 227
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 227
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 227
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 241
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 241
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 241
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 241
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 241
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 241
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 241
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 185
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 185
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 185
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 185
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 185
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 185
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 185
REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 395
REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 395
REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 395
REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 395
REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 395
REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 395
REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 395
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 171
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 171
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 171
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 171
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 171
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 171
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 171
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 255
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 255
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 255
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 255
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 255
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 255
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 255
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 269
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 269
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 269
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 269
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 269
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 269
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 269
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 283
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 283
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 283
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 283
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 283
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 283
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 283
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 297
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 297
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 297
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 297
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 297
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 297
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 297
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 325
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 325
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 325
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 325
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 325
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 325
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 325
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 311
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 311
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 311
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 311
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 311
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 311
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 311
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 353
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 353
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 353
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 353
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 353
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 353
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 353
REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 367
REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 367
REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 367
REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 367
REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 367
REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 367
REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 367
REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182 |  | 381
REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183 |  | 381
REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  | 381
REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186 |  | 381
REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187 |  | 381
REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191 |  | 381
REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192 |  | 381