I am looking to create a formula for the following data set.
Each rep is designated an ID number (example: 15890)
Each rep has a known start date (example 1/2/2017) , and known 90 day review date (example 4/1/2017)
I have a column per day, and for every sale the rep's ID number is placed in the column for that day.
1/1 ........ 1/2 etc.....
15890 15890
15890 14768
14756 17635
19547 18472
10748 16532
I want to count how many sales each rep has in their first 90 days.
Reps have different start dates, reps sell from 0-10+ times a day, and the data starts January 1 and goes to December 31.
Regular countif doesn't work- I have been working around countifs and can't get it to work...
Any help is appreciated
Each rep is designated an ID number (example: 15890)
Each rep has a known start date (example 1/2/2017) , and known 90 day review date (example 4/1/2017)
I have a column per day, and for every sale the rep's ID number is placed in the column for that day.
1/1 ........ 1/2 etc.....
15890 15890
15890 14768
14756 17635
19547 18472
10748 16532
I want to count how many sales each rep has in their first 90 days.
Reps have different start dates, reps sell from 0-10+ times a day, and the data starts January 1 and goes to December 31.
Regular countif doesn't work- I have been working around countifs and can't get it to work...
Any help is appreciated