Spreadsheet: 765722d1643548181-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Lists

Sales Reps | Date | Type | Year | FSM | Desking Manager | Status | Source | Counter | Lenders | Status | Year | 2019 | 2020 | Drivetrain | Transmission | 0 | AUTO - DRIVETRAIN |  | ESSENTIAL TRANS |  | 2019
[NAME] | 2022-01-01 00:00:00 | NEW | 2023 | [NAME] | [NAME] | Dead | Drive By | Yes | Finance | Landed | _2020 | ACCENT_SEDAN | ACCENT_SEDAN | AWD | Manual |  | FWD |  | AUTO |  | [NAME] | [NAME] | ELANTRA | ELANTRA GT | KONA | SONATA | TUCSON | SANTAFE | SANTA_FE_XL | IONIQHYBRID | IONIQEV | IONIQEVPLUS | PALISADE | VELOSTER | ELANTRA SPORT
[NAME] |  | USED | 2022 | [NAME] | [NAME] | Delivered | Dealbase | No | Cash | Incoming | _2021 | ACCENT_HATCH | ACCENT_HATCH | FWD | Auto |  | AWD |  | MANUAL |  | PREFERRED | PREFERRED | ESSENTIAL | PREFERRED | ESSENTIAL | ESSENTIAL SPORT | ESSENTIAL | ESSENTIAL | ESSENTIAL | PREFERRED | PREFERRED | PREFERRED | ESSENTIAL | PREFERRED | SPORT
[NAME] |  | F/O | 2021 | [NAME] | [NAME] | Factory Order | Referral |  | Lease |  |  | ELANTRA | ELANTRA |  | IVT |  |  |  |  |  | ULTIMATE | ULTIMATE | PREFERRED | LUXURY | PREFERRED | PREFERRED | ESSENTIAL SAFETY | ESSENTIAL SAFETY | PREFERRED | ULTIMATE | ULTIMATE | ULTIMATE | PREFERRED | LUXURY
[NAME] |  |  | 2020 | House | Danielle Jones | Locate | Repeat |  |  |  |  | KONA | KONA |  |  |  | MANUAL - DRIVETRAIN |  | SUNSAFETY TRANS |  |  |  | PREFERRED SUN / SAFETY | N-LINE | PREFERRED TW0-TONE | LUXURY | PREFERRED | PREFERRED | LUXURY 6 PASS |  |  |  | LUXURY 7 PASS | TURBO
[NAME] |  |  | 2019 |  |  | Sold | Private Sale |  |  |  |  | SONATA | SONATA |  |  |  | FWD |  | AUTO |  |  |  | LUXURY |  | TREND TWO-TONE | ULTIMATE | PREFERRED TREND | PREFERRED TREND | LUXURY 7 PASS |  |  |  | LUXURY 9 PASS | N-LINE
[NAME] |  |  | 2018 |  |  | [NAME] | eDealer |  |  |  |  | TUCSON | TUCSON |  |  |  | AWD |  | MANUAL |  |  |  | ULTIMATE |  | LUXURY |  | LUXURY | LUXURY | ULTIMATE 6 PASS |  |  |  | ULTIMATE
[NAME] |  |  | 2017 |  |  |  | Walk - In |  |  |  |  | SANTA_FE | SANTA_FE |  |  |  |  |  |  |  |  |  |  |  | ULTIMATE |  | ULTIMATE | ULTIMATE | ULTIMATE 7 PASS
[NAME] |  |  | 2016 |  |  |  | Other |  |  |  |  | SANTA_FE_XL | SANTA_FE_XL |  |  |  |  |  | LUXURY TRANS
House |  |  | 2015 |  |  |  | Bumper |  |  |  |  | IONIQ_HYBRID | IONIQ_HYBRID |  |  |  |  |  | AUTO
 |  |  | 2014 |  |  |  | Lease Pull |  |  |  |  | IONIQ_EV | IONIQ_EV |  |  |  |  |  | MANUAL
 |  |  | 2013 |  |  |  | Service |  |  |  |  | IONIQ_EVPLUS | IONIQ_EVPLUS
 |  |  | 2012 |  |  |  |  |  |  |  |  | PALISADE | PALISADE |  |  |  |  |  | PREFERRED TRANS |  | 2020
 |  |  | 2011 |  |  |  |  |  |  |  |  | VELOSTER | VELOSTER |  |  |  |  |  | AUTO |  | [NAME] | [NAME] | ELANTRA | ELANTRA GT | KONA | SONATA | TUCSON | SANTA FE | SANTA FE XL | IONIQ HYBRID | IONIQ EV | IONIQ EVPLUS | PALISADE | VELOSTER | ELANTRA SPORT
 |  |  | 2010 |  |  |  |  |  |  |  |  | ELANTRA SPORT | ELANTRA SPORT |  |  |  |  |  | MANUAL |  | PREFERRED | PREFERRED | ESSENTIAL | PREFERRED | ESSENTIAL | ESSENTIAL SPORT | ESSENTIAL | ESSENTIAL | ESSENTIAL | PREFERRED | PREFERRED | PREFERRED | ESSENTIAL | PREFERRED | SPORT
 |  |  | 2009 |  |  |  |  |  |  |  |  | ELANTRA GT | ELANTRA GT |  |  |  |  |  |  |  | ULTIMATE | ULTIMATE | PREFERRED | LUXURY | PREFERRED | PREFERRED | ESSENTIAL SAFETY | ESSENTIAL SAFETY | PREFERRED | ULTIMATE | ULTIMATE | ULTIMATE | PREFERRED | LUXURY
 |  |  | 2008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ULTIMATE TRANS |  |  |  | PREFERREDSUN SAFETY | N-LINE | PREFERRED TW0-TONE | LUXURY | PREFERRED | PREFERRED | LUXURY 6 PASS |  |  |  | LUXURY 7 PASS | TURBO
 |  |  | 2007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUTO |  |  |  | LUXURY |  | TREND TWO-TONE | ULTIMATE | PREFERRED TREND | PREFERRED TREND | LUXURY 7 PASS |  |  |  | LUXURY 9 PASS | N-LINE
 |  |  | 2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MANUAL |  |  |  | ULTIMATE |  | LUXURY |  | LUXURY | LUXURY | ULTIMATE 6 PASS |  |  |  | ULTIMATE
 |  |  | 2005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ULTIMATE |  | ULTIMATE | ULTIMATE | ULTIMATE 7 PASS
 |  |  | 2004 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 - 2020
 |  |  | 2003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS | COLOURS
 |  |  | 2002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACCENT ** | FIREY RED | POLAR WHITE | INTENSE BLUE | TANGERINE COMET | STORMY CLOUD | AQUA BLUE | SCARLET RED | [NAME] | POLAR WHITE | POLAR WHITE | POLAR WHITE | SIERRA BURGUNDY | TANGERINE COMET | LAVA ORANGE
 |  |  | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIREY RED | AURORA BLACK | SPACE BLACK | SPACE BLACK | ACID YELLOW | ICE WHITE | ASH BLACK | LAVE ORANGE | BECKETTS BLACK | PHANTOM BLACK | PHANTOM BLACK | PHANTOM BLACK | MOONLIGHT CLOUD | PHANTOM BLACK | PLATINUM SILVER
 |  |  | 2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AURORA BLACK | SNOW WHITE PEARL | INTENSE BLUE | PLATINUM SILVER | PULSE RED | PHANTOM BLACK | WINTER WHITE | TWILIGHT BLACK | NIGHT SKY PEARL | PLATINUM SILVER | PLATINUM SILVER | PLATINUM SILVER | BECKETTSBLACK | CHALK WHITE | IRON GREY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SNOW WHITE PEARL | SILKY SILVER | TYPHOON SILVER | POLAR WHITE | CHLAK WHITE | PLATINUM SILVER | COLISEUM GREY | QUARTZ WHITE | IRON FROST | IRON GREY | IRON GREY | IRON GREY | [NAME] | SHOOTING STAR MATTE | POLAR WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SILKY SILVER | AZURE BLUE | FIREY RED | IRON GREY | LAKE SILVER | COAST BLUE | [NAME] | STORMY SEA | MONACO WHITE | AURORA SILVER | AURORA SILVER | AURORA SILVER | LAGOON SILVER | DARK NIGHT | SPACE BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AZURE BLUE | URBAN GREY | LAVA ORANGE | STAR GAZING BLUE | DARK NIGHT | FIREY RED | GEMSTONE RED | RAINFOREST | JAVA ESPRESSO | CAFÉ BROWN | CAFÉ BROWN | CAFÉ BROWN | STEEL GRAPHITE | SPACE GREY | INTENSE BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | URBAN GREY |  | IRON GREY | FIREY RED | BLUE LAGOON | MARINA BLUE | DUSK BLUE | EARTHY BRONZE |  | FIREY RED | FIREY RED | FIREY RED | RAINFOREST | IGNITE FLAME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ELANTRA ** |  | THE DENIM | LAVA ORANGE |  |  |  |  |  | INTENSE BLUE | INTENSE BLUE | INTENSE BLUE | TAIGA BROWN | COBALT ECLIPSE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POLAR WHITE |  |  |  |  |  |  |  |  | LAVA ORANGE | LAVA ORANGE | LAVA ORANGE |  | LAKE SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPACE BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTENSE BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TYPHOON SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIREY RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAVA ORANGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRON GREY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THE DENIM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ELANTRA GT **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTENSE BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPACE BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLATINUM SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POLAR WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRON GREY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STAR GAZING BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIREY RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAVA ORANGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KONA **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANGERINE COMET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACID YELLOW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PULSE RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHLAK WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAKE SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DARK NIGHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLUE LAGOON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SONATA **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STORMY CLOUD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ICE WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHANTOM BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLATINUM SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COAST BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIREY RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARINA BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUCSON **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AQUA BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ASH BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WINTER WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COLISEUM GREY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GEMSTONE RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DUSK BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IONIQ **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POLAR WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHANTOM BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLATINUM SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRON GREY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AURORA SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAFÉ BROWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIREY RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTENSE BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAVA ORANGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PALISADE **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIERRA BURGUNDY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MOONLIGHT CLOUD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BECKETTSBLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAGOON SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STEEL GRAPHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RAINFOREST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAIGA BROWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VELOSTER **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TANGERINE COMET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHANTOM BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHALK WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHOOTING STAR MATTE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DARK NIGHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPACE GREY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IGNITE FLAME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COBALT ECLIPSE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAKE SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ELANTRA SPORT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAVA ORANGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PLATINUM SILVER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRON GREY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POLAR WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPACE BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTENSE BLUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SANTA FE **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCARLET RED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAVE ORANGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TWILIGHT BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUARTZ WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STORMY SEA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RAINFOREST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EARTHY BRONZE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SANTA FE XL **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BECKETTS BLACK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NIGHT SKY PEARL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRON FROST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONACO WHITE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAVA ESPRESSO