Hello Excel Wizards! I’m hoping someone can help me as I’m going out of my mind.

I’m creating a stats sheet to record contact types made throughout the year, broken down into a monthly view. I’m currently trying to establish a formula to tell me the number of phone calls made in a month to a unique person (I.e. if they’ve had multiple calls in July, then they’re only counted once)



Cell references:-

Contact date: July!A:A

Contact name: July!B:B

Contact type: July!D:D



At present, my formula counts unique contacts within the stipulated dates for July, I just can’t work out how I add that I also need it to consider the contact type made.



Formula I’ve currently got:

=SUMPRODUCT(IF((July!$A$2:$A$2499<=DATE(2022,7,31))*( July!$A$2:$A$2499>=DATE(2022,7,1)), 1/COUNTIFS(July!$A$2:$A$2499,"<="&DATE(2022,7,31), July!$A$2:$A$2499, ">="&DATE(2022,7,1), July!$B$2:$B$2499,July!$B$2:$B$2499), 0))


As much as I would love to use a pivot table for this, it's not an option.

Any help where to add the stipulation of contact type to this would be greatly appreciated!