I have a spreadsheet containing data from our support ticketing system. I have a formula that has been killing me and am looking for any help I can get!

I'm looking to count the total number of unique ticket numbers for each individual where the ticket had a activity of escalation. I also need to verify that the Call Driver is homes. Here's what I've tried.

b c f k

Activity Type Activity Logged By Ticket # Call Driver

Escalation Steve Smith 2885656 Homes

Escalation Steve Smith 2885656 Homes

Inbound email Steve Smith 2885656 Homes

Escalation Steve Smith 2890000 Homes

Escalation Steve Smith 2870000 Streets

=SUM(IF(FREQUENCY(IF(C:$C="Steve Smith",F:F)*(B:B="Escalation")*(k:k="Homes"),F:F)>0,1))

The result should be 1 because there is only one unique ticket # by steve smith that was a escalation for homes.

Thanks so much for any assistance!