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

AUGUST 2023 |  |  |  |  | tracking |  | 5 | 27
 | 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
20 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KAREN
21 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RUSS
22 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUSTIN
23 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NICOLE
24 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LUKAS
25 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLAYTON
26 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HIRAM
27 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
28 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
29 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
30 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
31 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
32 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
33 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
34 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
35 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
36 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
37 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
38 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
39 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
40 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
41 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
42 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
43 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
44 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
45 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
46 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
47 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
48 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
49 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
50 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
51 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
52 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
53 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
54 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
55 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
56 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
57 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
58 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
59 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
60 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
61 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
62 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
63 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
64 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
65 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
66 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
67 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
68 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
69 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
70 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
71 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
72 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
73 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
74 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
75 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
76 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
77 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
78 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
79 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
80 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
81 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
82 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
83 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
84 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
85 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
86 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
87 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
88 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
89 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
90 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
91 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
92 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
93 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
94 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
95 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
96 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
97 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
98 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
99 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
100 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
101 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
102 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
103 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
104 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
105 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
106 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
107 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
108 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
109 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
110 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
111 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
112 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
113 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
114 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
115 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
116 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
117 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
118 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
119 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
120 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
121 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
122 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
123 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
124 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
125 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
126 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
127 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
128 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
129 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
130 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
131 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
132 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
133 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
134 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0