Spreadsheet: 767530d1644507915-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
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
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
COUNT | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
COUNT | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
COUNT | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
COUNT | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
COUNT | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
MAX HOURS | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
MAX HOURS | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
TRUCK REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
TRUCK REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
TRUCK REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
TRUCK REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
TRUCK REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
TRUCK REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
TRUCK REVENUE | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
MAX HOURS | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
MAX HOURS | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
MAX HOURS | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
MAX HOURS | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
REVENUE | GMC |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
REVENUE | Ford F150 |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
REVENUE | Toyota |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
REVENUE | Light Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
TRUCK REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
TRUCK REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
TRUCK REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
TRUCK REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
TRUCK REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
TRUCK REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
TRUCK REVENUE | Medium Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
TRUCK REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
TRUCK REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
TRUCK REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 185
TRUCK REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 186
TRUCK REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 187
TRUCK REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 191
TRUCK REVENUE | Heavy Duty |  |  |  |  |  |  |  |  |  |  |  |  |  | 192