Spreadsheet: 838853d1691459843-having-problems-using-countifs-when-the-initial-criteria-is-a-name-in-the-list-elog-example
Sheet: Sheet1

AUGUST 2023 |  |  |  |  | tracking |  | 5 | 27
Column1 | DATE | Deal # | TRADE STOCK | Trade | ACV | Customer Name | AGE | Vehicle Type | INS | F&I | Stock # | FRONT END VEHICLE GROSS | BACK END VEHICLE GROSS | VEHICLE DEAL TOTAL GROSS | [NAME] | ETCH | KAHU | Fob | glass | REVIEW | CPOV | UVDR | MANAGER
1 | 2023-08-01 00:00:00 | 288543 | NT | NT | NT | RHODES | 8 | 2023 RAM 1500 | NO | $ | 608090A | 5044.51 | 0 |  | HIRAM | Y | Y |  |  |  | CPOV |  | DON |  |  |  | [NAME] | CORY | SHANE
2 | 2023-08-01 00:00:00 | 288551 | 7992851A | 2015 RAM 1500 | 10000 | HARRIS | 24 | 2019 RAM 1500 | YES | F&I | 515979A | 5916.56 | 2063.21 |  | [NAME] |  |  |  |  |  | CPOV |  | DON |  |  | #
3 | 2023-08-02 00:00:00 | 288568 | NT | NT | NT | EASLEY | 2 | 2019 RAM 1500 | YES | F&I | 664344A | 2350 | 1077 |  | LEA |  |  |  |  |  |  |  | SHANE |  |  | FEG
4 | 2023-08-02 00:00:00 | 288557 | NT | NT | NT | SALMON | 8 | 21 CHALLENGER | NO | F&I | 526004A | 3924 | 2420 |  | KALEB |  |  |  |  |  | CPOV |  | SHANE |  |  | BEG
5 | 2023-08-02 00:00:00 | 288579 | NT | NT | NT | KINNEY | 6 | 2015 TOYOTA SIENNA | NO | F&I | 575236A | 847 | 200 |  | HOUSE |  |  |  |  |  |  |  | [NAME] |  |  | TOT
6 | 2023-08-03 00:00:00 | 288587 | NT | NT | NT | HAMMONTREE | 23 | 2016 FRONTIER | YES | F&I | B792758 | 1990 | 1065 |  | LUKAS |  |  |  |  |  |  |  | [NAME] |  |  | PRU |  |  |  |  | Start | End |  |  | Start | End |  |  | Start | End |  |  | Start | End
7 | 2023-08-03 00:00:00 | 288598 | 157408A | 19 2500 | 46500 | MAREK | 5 | 19 1500 | NO | F&I | 769379B | 2892 | 1149 |  | KAREN |  | Y |  |  |  | CPOGO |  | SHANE | $$ paid |  |  |  |  |  |  | 2023-08-03 00:00:00 | 2023-08-09 00:00:00 |  |  | 2023-08-10 00:00:00 | 2023-08-16 00:00:00 |  |  | 2023-08-17 00:00:00 | 2023-08-23 00:00:00 |  |  | 2023-08-24 00:00:00 | 2023-08-30 00:00:00
8 | 2023-08-04 00:00:00 | 288624 | NT | NT | NT | DAVIS | 20 | 2013 AVENGER | NO | F&I | 882803A | 3039 | 0 |  | RUSSEL |  |  |  |  |  |  |  | SHANE
9 | 2023-08-04 00:00:00 | 288643 | 638131B | 13 WRANGLER | 6000 | [NAME] | 13 | 2011 YUKON | YES | F&I | 638131A | 4501 | 732 |  | CASEY |  |  |  |  |  |  |  | SHANE |  |  |  |  |  |  |  | 20 | 10 | TOTAL |  | 20 | 10 | TOTAL |  | 20 | 10 | TOTAL |  | 20 | 10 | TOTAL
10 | 2023-08-05 00:00:00 | 288659 | 555317B | 08 RAM | 2500 | WARFIELD | 12 | 2019 RANGER | YES | F&I | 555317A | 3809 | 3057 |  | JJ |  |  |  |  |  |  |  | CORY
11 | 2023-08-05 00:00:00 | 288663 | NT | NT | NT | CLARK | 57 | 2021 ACADIA |  |  | 848808A | -1665 | 2090 |  | CLAYTON |  | Y |  |  |  |  |  | SHANE |  |  |  |  |  |  |  | Aug 3 - Aug 9 |  |  |  | Aug 10 - Aug 16 |  |  |  | Aug 17 - Aug 23 |  |  |  | Aug 24 - Aug 29
12 | 2023-08-05 00:00:00 | 288679 | 856789A | 136 JUKE | 5000 | CHRISTIANSEN | 29 | 2023 HORNET | YES | F&I | 856789A | 3999 | 1234.31 |  | MARK P | Y | Y |  |  |  | CPOV |  | ALEX |  |  |  |  |  |  | MARKO
13 | 2023-08-05 00:00:00 | 288694 | NT | NT | NT | VAN DUSEN | 32 | 2018 RAM 1500 | NO | NO | B309298 | -2860 | 0 |  | LEA |  |  |  |  |  |  |  | CORY |  |  |  |  |  |  | ITZEL
14 | 2023-08-05 00:00:00 | 288704 | NT | NT | NT | REYES | 2 | 2019 RAM 1500 | NO | NO | 636351A | 4534 | 0 |  | MARKO |  |  |  |  |  |  |  | SHANE |  |  |  |  |  |  | KALEB
15 | 2023-08-05 00:00:00 | 288697 | NT | NT | NT | [NAME] | 60 | 2020 DURANGO | NO | F&I | 589715A | -1762 | 102.82 |  | MAURICE |  |  |  |  |  | CPOV |  | CORY |  |  |  |  |  |  | LEA
16 | 2023-08-05 00:00:00 | 288708 | B171419A | 2006 Expedition | 1000 | WELLINGER | 25 | 2012 SILVERADO | NO | F&I | B171419 | 1178.48 | 369 |  | MARKO |  |  |  |  |  |  |  | SHANE |  |  |  |  |  |  | CLAUDIA
17 | 2023-08-05 00:00:00 | 288613 | B646249A | 2021 Challenger | 21000 | GOMES | 1 | 2021 CHALLENGER | NO | F&I | B646249 | 5327 | 2927 |  | CLAUDIA |  |  |  |  |  | CPOV |  | CORY |  |  |  |  |  |  | CASEY
18 | 2023-08-05 00:00:00 | 288711 | A55823A | 2022 Kia | 34000 | NICHOLS | 12 | 2020 EXPEDITION | YES | F&I | 848182A | 1277 | 3527 |  | MARKO |  |  |  |  |  |  |  | SHANE |  |  |  |  |  |  | [NAME]
19 | 2023-08-05 00:00:00 | 288707 | NT | NT | NT | PARK | 9 | 2014 JEEP WRANGLER | NO | F&I | B176817 | 4003.56 | 200 |  | ITZEL |  |  |  |  |  | CPOGO |  | [NAME] |  |  |  |  |  |  | JJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KAREN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RUSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUSTIN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NICOLE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LUKAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLAYTON
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HIRAM