Counting using frequency formula with multiple criteria

[dwood]

I am creating a spreadsheet for a banking institution to calculate incentive payments based on the number of transactions entered in a single month. The calculation I am having trouble with is determining the number of days the teller actually worked in the month based on the dates that transaction were entered by the individual teller. I have three columns of information that I need to extract information from. Column "A" includes all tellers initials, Column "B" includes all transaction codes completed in the date range, and Column "C" includes all dates transaction were entered. The frequency formula,
=SUM(IF(FREQUENCY(c6:c65000,c6:c65000)>0,1)) will give me the number of unique dates in the date range, but I also need to determine this for each individual teller. I have tried a variety of "IF" combinations, but cannot get them to combine both criteria. I want to use an array formula if possible. Any suggestions?

 

[Domenic]

Try...

=SUM(IF(FREQUENCY(IF(A6:A100=E2,IF(C6:C100<>"",C6:C100)),IF(A6:A100=E2,IF(C6:C100<>"",C6:C100))),1))

...where E2 contains the teller's initials. Note that the formula needs to be confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

 

[dwood]

This worked perfectly, thanks for your help.

 

[rvchahar]

MAX(FREQUENCY(IF(($G$2:$G$59=1)+($E$2:$E$59=A4)+($F$2:$F$59>=B4+$C$1)+($F$2:$F$59<=B4+$C$2)=4,ROW($G$2:$G$59)),IF(($G$2:$G$59=1)+($E$2:$E$59=A4)+($F$2:$F$59>=B4+$C$1)+($F$2:$F$59<=B4+$C$2)<4,ROW($G$2:$G$59))))

i am try to get the max frequency on multiple condition and this formula works but due to this excel sheet gonna freez so is their any other formula which help me in the same manner without hang my excel sheet help me please