Frequency with Multiple Criteria

[Moxioron]

Good morning.

I am trying to count the unique values/labels in column A. Here are the specifics:

Column A = Employee Name
Column Q = Queue Name
Column S = Date

I have tried these two thus far and am met with zero as a result (which isn't correct):

{=SUM(IF(FREQUENCY(IF(Detail!$Q$6:$Q$25000=B20,IF(Detail!$S$6:$S$25000>=$E$15,IF(Detail!$S$6:$S$25000<=$F$15,Detail!$A$6:$A$25000))),Detail!$A$6:$A$250000),1))}
{=COUNT(IF(FREQUENCY(IF(Detail!$Q$6:$Q$25000=B20,IF(Detail!$S$6:$S$25000>=$E$15,IF(Detail!$S$6:$S$25000<=$F$15,Detail!$A$6:$A$25000))),Detail!$A$6:$A$25000),1))}

Where am I going awry? Thanks.

 

[Eric W]

How about:

=SUM(SIGN(FREQUENCY(IF(Detail!$Q$6:$Q$25000=B20,IF(Detail!$S$6:$S$25000>=$E$15,IF(Detail!$S$6:$S$25000<=$F$15,MATCH(Detail!$A$6:$A$25000,Detail!$A$6:$A$25000,0)))),ROW(Detail!$A$6:$A$25000)-ROW($A$6)+1)))

The main thing you were missing was the MATCH function, and adjusting the row range in the second FREQUENCY array.

 

[Moxioron]

Thank you Eric. That worked. That is quite a robust statement.