# Thread: Count occurances between dates (2003 SP2)

1. ## Count occurances between dates (2003 SP2)

I am trying to count the number of times salesmans' initials appear in 2 columns between 2 dates, but not only individually but also with another sales person.
Thanks
Gazza

2. ## Re: Count occurances between dates (2003 SP2)

Do the SUMPRODUCT formulas in the attached workbook do what you want? If not, please provide more info.

3. ## Re: Count occurances between dates (2003 SP2)

Another formula you might want based on your questions (and using Hans' workbook) is:

=SUMPRODUCT((C5:C13>=D22)*(C5:C13<=D23)*(D513=D25)*(E5:E13=""))+SUMPRODUCT((C5:C13>=D22)*(C5: C13<=D23)*(D513="")*
(E5:E13=D25))

This will give the count of the person individually: If they have no "partners". That is to say that their initials are in D and no-one is in E or their initials are in E and no one is in D. Hans' formula will count whether they are alone or with a partner.

Steve

4. ## Re: Count occurances between dates (2003 SP2)

Thanks Hans & Steve, the responses give me the result I am looking for.
Gazza

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•