Counting Unique Fields with Conditions

[Moxioron]

Hello.

I am able to successfully get the number of unique days between two dates using:

=SUM(IF(FREQUENCY(IF(Detail!$Q$4:$Q$15000>=$B$3,IF(Detail!$Q$4:$Q$15000<=$C$3,Detail!$Q$4:$Q$15000)),Detail!$Q$4:$Q$15000),1))

However, I can't figure out how to add another variable. I am trying to count the number of days a user (column B) was logged into the phone system.

Example:
Martha had 445 phone calls between 01/01/2020 and 01/31/2020 and was logged in 22 of those days.

Any assistance would be appreciated. Thank you.

 

[C Moore]

What version of Excel do you have?

 

[Moxioron]

Microsoft Office Professional Plus 2019

 

[Fluff]

Can you please update your account details to show your versio, it saves members from having to ask all the time. Thanks.