Spreadsheet: 768749d1645107752-sumproduct-formula-to-count-multiple-text-excel-help
Sheet: Sheet1

Vehicle | Operator | Driver | Labourer | Number in Crew | Contract | Depot |  | No. nights accom | TM Days | m3       Monday | m3       Tuesday | m3 Wednesday | m3     Thursday | m3            Friday | m3      Saturday | m3         Sunday | Total Output m3 | CONTRACT PERFORMANCE | CONTRACT PERFORMANCE
V9 VPL |  |  |  |  | Norfolk |  |  |  |  | X | X | X | X | X | X | X |  | MACHINES OUT | 7
V11 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | Weekly Combined              Contract Profit
V15 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | CORNWALL  PROFIT
V16 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | CORNWALL DAYS WORKED
V18 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | CORNWALL DAYS LOST | 7
V21 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | CORNWALL DAILY AVERAGE M3
V24 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | NORFOLK PROFIT
V25 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | NORFOLK DAYS WORKED
V26 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | NORFOLK DAYS LOST | 6
V27 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | NORFOLK DAILY AVERAGE M3
V28 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | HEREFORD PROFIT
V29 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X |  | HEREFORD DAYS WORKED
V30 VPL |  |  |  |  | Cornwall |  |  |  |  | WEATHER | TRUCK BREAK DOWN | AGENCY CREW ISSUE | UNIT BREAKDOWN | VELOCITY CREW ISSUE | X | X |  | HEREFORD DAYS LOST | 5 | hi all, im trying to make a formula to count the yealow highlited areas from Monday to Friday,for each of the areas we work in I want it to ignore the xs and any number and just count text, I thought I had it cracked but when I move the formula other cells counting agency crew issues in all three. hilight the figures in red what i should get back
V31 VPL |  |  |  |  | Herefordshire |  |  |  |  | WEATHER | TRUCK BREAK DOWN | AGENCY CREW ISSUE | UNIT BREAKDOWN | VELOCITY CREW ISSUE | X | X |  | [NAME] AVERAGE M3
V33 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V40 VPL |  |  |  |  | Norfolk |  |  |  |  | WEATHER | TRUCK BREAK DOWN | AGENCY CREW ISSUE | UNIT BREAKDOWN | VELOCITY CREW ISSUE | X | X
[NAME] |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V50 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
GN59 GXE |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
KY60 WUP |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V66 VPL mon-tue |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
V77 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V60 VPL |  |  |  |  | Cornwall |  |  |  |  | WEATHER | WEATHER | X | X | X | X | X
SJ12 XVB |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V55 VPL |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
V66 VPL wed-thur |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
[NAME] fri-sat |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
V30 VPL fri - sat |  |  |  |  | Cornwall |  |  |  |  | X | X | X | X | X | X | X
V9 VPL fri |  |  |  |  | Norfolk |  |  |  |  | WEATHER | X | X | X | X | X | X
 |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
 |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
 |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
 |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X