Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# CountIF between date range with Multiple Criteria

Posted on 2013-02-06
Medium Priority
932 Views
Hi Experts,

I have a workbook where I need to count the number of Interactions between a date range based on an employees name and wanted to know if this can be done?

Attached is a sample workbook with the following formula

=SUMPRODUCT((RLOFTracker[Date Worked]>=\$F\$1)*(RLOFTracker[Date Worked]<=\$G\$1)*(RLOFTracker[CQ Agent]=A2)*(RLOFTracker[Interaction ID]))

Col A has the Employee Names, Col B is where I have the above formula, Col F & G holds the dates.

I have a table that's holding the Interactions each employee had on a specified date.  I need to count the number of Interactions an Employee had between a date range
EE-CountIF-Multiple-Criteria.xlsx
0
Question by:"Abys" Wallace

LVL 7

Accepted Solution

leptonka earned 2000 total points
ID: 38862802
Hi,
If you would like to count, you do not need the number of interactions:

=SUMPRODUCT((RLOFTracker[Date Worked]>=\$F\$1)*(RLOFTracker[Date Worked]<=\$G\$1)*(RLOFTracker[CQ Agent]=A2))

or if you are not sure the ID is filled or not:
=SUMPRODUCT((RLOFTracker[Date Worked]>=\$F\$1)*(RLOFTracker[Date Worked]<=\$G\$1)*(RLOFTracker[CQ Agent]=A2)*(RLOFTracker[Interaction ID]<>""))

Cheers,
Kris
``````=SUMPRODUCT((RLOFTracker[Date Worked]>=\$F\$1)*(RLOFTracker[Date Worked]<=\$G\$1)*(RLOFTracker[CQ Agent]=A2))
``````
0

LVL 24

Expert Comment

ID: 38862941
Is the attached what you were looking for: Using COUNTIFS

=COUNTIFS(RLOFTracker[CQ Agent],Sheet1!A2,RLOFTracker[Date Worked],">="&Sheet1!\$F\$1,RLOFTracker[Date Worked],"<="&Sheet1!\$G\$1)
EE-CountIF-Multiple-Criteria.xlsx
0

Author Closing Comment

ID: 38863360
Works great!  Thank you leptonka
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
I came across an unsolved Outlook issue and here is my solution.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
###### Suggested Courses
Course of the Month11 days, 8 hours left to enroll