Spreadsheet: 835285d1688481245-solved-need-help-with-countifs-frmla-to-get-a-result-from-3-different-columns-and-ranges-book1-2-
Sheet: 01WkdyWB

 |  |  |  | G
 | 18K |  | 13422828
 | 18C |  | 13422828 | 18051
 | 18K |  | 13422828 | 1005
 |  |  | 13422828 | 1705
 | 18 |  | 13422828 | 1007
 |  |  | 13422828 | 1707
 | 18K |  | 13422828 | 1009
 |  |  | 13422828 | 1709
 | 18 |  | 13422828 | 1011
 |  |  | 13422828 | 1711
 |  |  | 13422828 | 1961
 | 18K |  | 13422828 | 1013
 |  |  | 13422828 | 1713
 | 18 |  | 13422828 | 1015
 |  |  | 13422828 | 1715
 | 18K |  | 13422828 | 1017
 |  |  | 13422828 | 1717
 | 18K |  | 13422828 | 1019
 |  |  | 13422828 | 1719
 | 18K |  | 13422828 | 1021
 |  |  | 13422828 | 1721
 | 18 |  | 13422828
 |  |  | 13422828 | 1323
 |  |  | 13422828 | 1873
 |  |  | 13422828 | 1773
 |  |  | 13422828 | 1125
 |  |  | 13422828 | 1875
 | 18K |  | 13422828
 |  |  | 13422828 | 1325
 |  |  | 13422828 | 1877
 |  |  | 13422828 | 1775
 |  |  | 13422828 | 1127
 |  |  | 13422828 | 1977
 | 18 |  | 13422828
 |  |  | 13422828 | 1327
 |  |  | 13422828 | 1727
 |  |  | 13422828 | 1879
 | 18 |  | 13422828
 |  |  | 13422828 | 1729
 | 18 |  | 13422828
 |  |  | 13422828 | 1731
 | 18 |  | 13422828
 |  |  | 13422828 | 1733
 |  |  | 13422828 | 1035
 | 18 |  | 13422828
 |  |  | 13422828 | 1735
 | 18 |  | 13422828
 |  |  | 13422828 | 1987
 |  |  | 13422828 | 1737
 | 18 |  | 13422828
 |  |  | 13422828 | 1739
 | 18 |  | 13422828
 | 18H |  | 13422828 |  |  | M-Th | 35 |  | à |  | à |  | à |  | 53 |  | 105 |  | 01 20↓
 | 18A |  | 13422828 |  |  | M-Th | 100 |  | à |  | à |  | à |  | à |  | à |  | 01 30h |  | 138 |  | 148 |  | 200 |  | 210 |  | à |  | 210 |  | D02 17 |  | D02 30 |  | D02 40
 |  |  | 13422828 | 1741 |  | Fri | 44 |  | 52 |  | 101 |  | 107 |  | 113 |  | 120 |  | 127 |  | 133 |  | 139 |  | 145 |  | 152 |  | à |  | 152 |  | à |  | à |  | 206
 | 18H |  | 13422828 |  |  | FRI | 01 30 |  | à |  | à |  | à |  | 153 |  | 205 |  | 217 |  | 225 |  | 235 |  | 245 |  | 255 |  | à |  | 255 |  | D03 02 |  | D03 15
 | 18C |  | 13422828 |  |  |  | 02 30 |  | à |  | à |  | à |  | 253 |  | 305 |  | 317 |  | 325 |  | 335 |  | 343 |  | 353 |  | à |  | 353 |  | D04 00 |  | D04 10
 |  |  |  |  |  |  |  |  |  |  |  | Table 15 WeekDAY - EAST
 |  |  |  |  |  |  |  |  |  |  |  | Route |  | CURRENT TRIP MON - THU |  |  | CURRENT TRIP MON - FRI |  |  | CURRENT TRIP THU - FRI |  |  | CURRENT TRIP FRI ONLY |  |  | TTL | NEW TRIP MON - THU |  |  | NEW TRIP MON - FRI |  |  | NEW TRIP THU - FRI |  |  | NEW TRIP FRI ONLY |  |  | TTL | SEASONAL TRIP MON - THU |  |  | SEASONAL TRIP MON - FRI |  |  | SEASONAL TRIP FRI ONLY |  |  | TTL | CANCELLED TRIPS |  |  | TTL | SUBTOTAL  PER ROUTE
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 18A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 18C
 |  |  |  |  |  |  |  |  |  |  |  | 18H
 |  |  |  |  |  |  |  |  |  |  |  | 18K
 |  |  |  |  |  |  |  |  |  |  |  | Total(s)
 |  |  |  |  |  |  |  |  |  |  |  | Subtotal All Routes  ( New + Seasonal - Cancelled Trips )
 |  |  |  |  |  |  |  |  |  |  |  | Grand Total All Routes  ( Current + New + Seasonal - Cancelled Trips )