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.
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.