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