Spreadsheet: 682681d1592253128-count-in-multiple-columns-if-one-condition-is-met-in-a-different-column-bonus-log
Sheet: Sheet1

DATE | CUSTOMER | STOCK | N/U | YEAR | MAKE | MODEL | TRADE | ACV | CASH | TERM | GRADE | DAYS | SALES | TEN | OVER | DEL | SELECT | ZS | UNDER | True
2020-05-01 00:00:00 | SMITH | 123456 | U | 2013 | CHRYSLER | 200 | N/A |  |  |  |  | 519 | [NAME]
2020-05-01 00:00:00 | SMITH | 123456 | U | 2020 | CHEVROLET | TRAVERSE | N/A |  |  |  |  |  | DANIEL
2020-05-01 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | TAHOE | N/A |  |  |  |  |  | DANIEL
2020-05-01 00:00:00 | SMITH | 123456 | U | 2007 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 778 | [NAME] | 1 |  |  |  | 3 |  | 500
2020-05-01 00:00:00 | SMITH | 123456 | N | 2019 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 710 | [NAME] | 1 |  |  | 4 | 3 | 4 | 500
2020-05-02 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SILVERADO | 12 BMW 550I |  |  |  |  | 842 | BRENT |  | 2 |  |  | 3 |  | 500
2020-05-04 00:00:00 | SMITH | 123456 | U | 2016 | CHEVROLET | SILVERADO | 14 MAZDA CX-5 |  |  |  |  | 653 | [NAME] | 1 | 2 |  |  | 3 |  | 500
2020-05-04 00:00:00 | SMITH | 123456 | U | 2016 | TOYOTA | TUNDRA | 05 LEX GX470 |  |  |  |  | 769 | [NAME] |  |  |  |  |  |  | 500
2020-05-04 00:00:00 | SMITH | 123456 | U | 2018 | TOYOTA | TUNDRA | N/A |  |  |  |  |  | DANIEL |  |  | 4
2020-05-05 00:00:00 | SMITH | 123456 | U | 2019 | CHEVROLET | SILVERADO | N/A |  |  |  |  |  | DANIEL
2020-05-05 00:00:00 | SMITH | 123456 | U | 2019 | CADILLAC | XT4 | N/A |  |  |  |  |  | DANIEL | 1 |  |  |  | 3
2020-05-05 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 760 | JORDAN |  | 2 |  |  |  |  | 500
2020-05-05 00:00:00 | SMITH | 123456 | N | 2019 | CHEVROLET | SILVERADO | 20 FORD MUST |  |  |  |  | 750 | [NAME] | 1 | 2 |  |  |  |  | 500
2020-05-05 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | EQUINOX | 15 CHEV CAPTIVA |  |  |  |  | 679 | CHRIS |  |  | 4 |  |  |  | 500
2020-05-05 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SPARK | N/A |  |  |  |  | 728 | [NAME] |  | 2 |  |  | 3 |  | 500
2020-05-07 00:00:00 | SMITH | 123456 | N | 2019 | CHEVROLET | BLAZER | N/A |  |  |  |  | 607 | BRENT | 1 | 2 |  | 4 | 3 | 4 | 500
2020-05-08 00:00:00 | SMITH | 123456 | U | 2017 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 680 | JORDAN | 1 | 2 |  |  | 3 |  | 500
2020-05-08 00:00:00 | SMITH | 123456 | U | 2016 | CHEVROLET | EXPRESS | N/A |  |  |  |  |  | GRAHAM
2020-05-08 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | EQUINOX | N/A |  |  |  |  |  | BRENT
2020-05-09 00:00:00 | SMITH | 123456 | U | 2017 | CHEVROLET | TAHOE | N/A |  |  |  |  | 740 | DANIEL | 1 |  | 4 |  |  |  | 500
2020-05-09 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | EQUINOX | 17 FORD ESCAPE |  |  |  |  | 755 | GRAHAM |  |  |  |  |  |  | 500
2020-05-09 00:00:00 | SMITH | 123456 | U | 2016 | CADILLAC | CTS | N/A |  |  |  |  | 780 | GRAHAM | 1 | 2 | 4 |  | 3 |  | 500
2020-05-09 00:00:00 | SMITH | 123456 | U | 2020 | FORD | MUSTANG | N/A |  |  |  |  | 832 | CHRIS | 1 | 2 |  | 4 | 3 | 4 | 500
2020-05-11 00:00:00 | SMITH | 123456 | U | 2017 | GMC | ACADIA | 15 CHEV TRAVERSE |  |  |  |  | 859 | CHRIS |  | 2 |  |  |  |  | 500
2020-05-12 00:00:00 | SMITH | 123456 | U | 2017 | CHEVROLET | EQUINOX | 13 CHEV MALI |  |  |  |  | 757 | [NAME] | 1 | 2 |  | 4 | 3 |  | 500
2020-05-12 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SILVERADO | 16 RAM 1500 |  |  |  |  | 816 | [NAME] | 1 |  |  |  |  |  | 500
2020-05-12 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SPARK | 01 FORD EXPEDITION |  |  |  |  | 601 | [NAME] |  | 2 |  |  |  |  | 500
2020-05-14 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | TAHOE | 08 ACURA MDX |  |  |  |  | 791 | JORDAN | 1 |  | 4 |  | 3 |  | 500
2020-05-14 00:00:00 | SMITH | 123456 | U | 2015 | CHEVROLET | CAMARO | N/A |  |  |  |  | 676 | CHRIS |  | 2 |  |  |  |  | 500
2020-05-14 00:00:00 | SMITH | 123456 | U | 2019 | CHRYSLER | 300 | N/A |  |  |  |  | 667 | KAREN | 1 | 2 |  |  | 3 | 4 | 500
2020-05-15 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 834 | JORDAN | 1 |  |  |  |  | 4 | 500
2020-05-16 00:00:00 | SMITH | 123456 | U | 2012 | CHEVROLET | TAHOE | 08 MAZDA 3 |  |  |  |  | 716 | LABRISHA |  |  |  |  |  |  | 500
2020-05-16 00:00:00 | SMITH | 123456 | U | 2012 | BMW | 550I | N/A |  |  |  |  | 550 | JORDAN |  | 2 |  | 4 | 3 | 4 | 500
2020-05-16 00:00:00 | SMITH | 123456 | U | 2015 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 635 | CHRIS | 1 |  |  |  |  |  | 500
2020-05-16 00:00:00 | SMITH | 123456 | U | 2010 | FORD | F-250 | N/A |  |  |  |  | 675 | DANIEL |  | 2 |  |  |  |  | 500
2020-05-18 00:00:00 | SMITH | 123456 | U | 2019 | RAM | 1500 | 12 RAM 1500 |  |  |  |  | 839 | GRAHAM |  |  |  |  |  |  | 500
2020-05-18 00:00:00 | SMITH | 123456 | U | 2019 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 676 | JOSH | 1 | 2 |  |  | 3 |  | 500
2020-05-19 00:00:00 | SMITH | 123456 | U | 2015 | GMC | SIERRA | 06 FORD F150 |  |  |  |  |  | DANIEL |  | 2 |  |  |  |  | 500
2020-05-19 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | TRAX | 13 DODGE DART |  |  |  |  | 633 | JORDAN | 1 | 2 |  |  |  |  | 500
2020-05-19 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | BLAZER | 12 HYUN TUCSON |  |  |  |  | 689 | LABRISHA | 1 | 2 |  |  |  |  | 500
2020-05-19 00:00:00 | SMITH | 123456 | U | 2017 | RAM | 2500 | N/A |  |  |  |  |  | DANIEL
2020-05-21 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SILVERADO | 12 GMC YUKON |  |  |  |  | 775 | GRAHAM |  | 2 |  |  |  |  | 500
2020-05-21 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | EQUINOX | 14 CRUZE/18 TRAX |  |  |  |  |  | JORDAN |  |  | 4
2020-05-21 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | EQUINOX | 15 CHEV EQUINOX |  |  |  |  | 662 | JORDAN |  | 2 |  |  |  |  | 500
2020-05-22 00:00:00 | SMITH | 123456 | U | 2017 | JEEP | WRANGLER | 2012 NISS ALTIMA |  |  |  |  | 669 | [NAME] | 1 | 2 |  |  | 3 |  | 500
2020-05-23 00:00:00 | SMITH | 123456 | U | 2005 | TOYOTA | 4RUNNER | N/A |  |  |  |  |  | GRAHAM
2020-05-23 00:00:00 | SMITH | 123456 | U | 2018 | FORD | ESCAPE | N/A |  |  |  |  | 663 | LABRISHA | 1 | 2 |  |  | 3 |  | 500
2020-05-23 00:00:00 | SMITH | 123456 | U | 2017 | CHEVROLET | TAHOE | 17 RAM 1500 |  |  |  |  | 761 | DANIEL |  |  |  |  |  |  | 500
2020-05-23 00:00:00 | SMITH | 123456 | U | 2011 | DODGE | 3500 | N/A |  |  |  |  |  | KAREN
2020-05-25 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | TRAVERSE | N/A |  |  |  |  | 870 | GRAHAM |  |  | 4 |  |  |  | 500
2020-05-25 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 736 | CHRIS |  |  |  |  |  |  | 500
2020-05-26 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | EQUINOX | 10 TOYO SIENNA |  |  |  |  | 829 | GRAHAM |  |  |  |  | 3 |  | 500
2020-05-26 00:00:00 | SMITH | 123456 | U | 2012 | CADILLAC | SRX | N/A |  |  |  |  | 732 | DANIEL | 1 |  |  |  |  |  | 500
2020-05-28 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | BLAZER | 15 JEEP WRANGLER |  |  |  |  | 818 | JORDAN |  |  |  |  |  |  | 500
2020-05-28 00:00:00 | SMITH | 123456 | U | 2013 | CHEVROLET | MALIBU | 01 SATURN SC2 |  |  |  |  |  | GRAHAM
2020-05-28 00:00:00 | SMITH | 123456 | U | 2016 | RAM | 1500 | 07 BUICK LACROSSE |  |  |  |  | 727 | [NAME] |  | 2 |  |  |  |  | 500
2020-05-29 00:00:00 | SMITH | 123456 | N | 2020 | CHEVROLET | SILVERADO | N/A |  |  |  |  | 755 | BRENT | 1 | 2 |  | 4 | 3 | 4 | 500
2020-05-29 00:00:00 | SMITH | 123456 | U | 2012 | CHEVROLET | SILVERADO | 12 HONDA CIVIC |  |  |  |  | 597 | JORDAN |  |  |  |  |  |  | 500
2020-05-30 00:00:00 | SMITH | 123456 | U | 2018 | GMC | SIERRA | N/A |  |  |  |  | 734 | DANIEL |  | 2 |  |  |  |  | 500
 | Sales | TEN | OVER | ZS | Other
 | [NAME]
 | [NAME]
 | Jordan
 | [NAME]
 | Labrisha
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent
 | [NAME]