Count if Frequency based on 2 criteria

[jmazorra]

I worked out the formula below to count if frequency. However, now I need to work it out for 2 criterias.

Count if I:I = A2 and if R:R = Closed

What I have so far is this:

{=COUNT(IF(FREQUENCY(IF(ticketInformation!I:I=A2,ticketInformation!B:B),ticketInformation!B:B),1))}

 

[Firefly2012]

Put another If in there:

{=COUNT(IF(FREQUENCY(IF(ticketInformation!I:I=A2,IF(ticketInformation!R:R="Closed",ticketInformation!B:B)),ticketInformation!B:B),1))}

 

[jmazorra]

Thank you, that was it.