Spreadsheet: 453634d1459387426-count-if-help-workbook-example
Sheet: April

Quick note: | If you are spliting the appointment show /sold select the split option in the drop down and don’t forget to type the persons name in the split colum or else the numbers wont count right.
Representative Name |  |  |  | (DO NOT TOUCH THESE NUMBERS THEY UPDATE AUTOMATICLY)
Month | April |  | Store | Appt Set | Appt Show | Appt Sold | Store | Appt Set | Appt Show | Appt Sold
 |  |  | Hyundai/Mts |  |  |  | Toyota
 |  |  | Nissan |  |  |  | Mercedes |  |  |  |  | [NAME] for ERA |  | F | Funded
 |  |  | Cadillac |  |  |  | Motors |  |  |  |  |  |  | C | Contracted
 |  |  | Porche/Audi |  |  |  | CJDR |  |  |  |  |  |  | E | Pending contract
 |  |  | VOLKSWAGEN |  |  |  |  |  |  |  |  |  |  | S | Worked
 |  |  | Total Appt's set |  | Total Show's |  | Total Sold's |  | Total Show and Sold Monthly bonus
 |  |  | Total Appt's set GOAL |  | Total Show's GOAL |  | Total Sold's GOAL |  | GOAL
 |  |  | Total Gross
Store | First Name | Last Name | Phone Number /        Email address | Day Set | Appt Date | Sold Date | Show? | Sold? | Show Bonus | Sold Bonus | Deal Number | Split With? | Spiff? | Notes | ERA Status | Gross Profit
Hyundai/Mts | [NAME] | Doe |  | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 |  | NO | NO
Hyundai/Mts | [NAME] | Doe |  | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 |  | NO | NO |  |  |  | jane doe
Hyundai/Mts | [NAME] | Doe |  | 2016-03-31 00:00:00 | 2016-03-31 00:00:00 |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO
 |  |  |  |  |  |  | NO | NO