I have a data sheet with these specific columns (among others)
Date time (in one column) Campaign name (I work at a call center) in another Agent ID number in a third
What I am trying to do is pull how many agents worked in which campaign within a certain time-frame.
I can count total unique agents using =SUM(IF(FREQUENCY(Dials!D:D,Dials!D:D)>0,1))
and number of calls per hour etc using =COUNTIFS(Dials!A:A,">="&D3,Dials!A:A,"<="&F3,Dials!F:F,"5020"))
where 5020 is the campaign ID and D3 is the start of the hour and F3 the end of the hour.
However if I try to combine them to get the number of agents who worked on that campaign in that hour I get a zero result...
Any ideas?