S
SCC
We track the number of people who log into out computers. I have two countif
statements that I would like to combine. The first counts the number of
logins based on the time of day. There are three different statements.
=COUNTIF('LC371Logins Unique'!L977:L1013,"<12:00 PM")
=COUNTIFS('LC371Logins Unique'!L977:L1013,">12:00 PM",'LC371Logins
Unique'!L977:L1013,"<4:00 PM")
=COUNTIF('LC371Logins Unique'!L977:L1013,">4:00 PM")
The second counts the number of sessions based on the durration. Again,
there are three different statements.
=COUNTIF('LC371Logins Unique'!$O$2:O1265,"<0:15")-COUNTIF('LC371Logins
Unique'!$O$977:O1036,"<0:15")
=COUNTIF('LC371Logins Unique'!$O$2:O1265,">=0:15")-COUNTIF('LC371Logins
Unique'!$O$2:O1265,">0:35")
=COUNTIF('LC371Logins Unique'!$O$2:O1265,">0:35")
What I need to know is how many sessions are less than 15 minutes before
12:00 pm, between 12:00 and 4:00 pm, and after 4:00 pm. This then needs to
be done for sessions between 15 and 35 minutes and for sessions over 35
minutes. I will create separate functions for each question.
How would you combine the two conditions into one function? I know in other
programs I would use a WHERE statement for the second condition. How would I
combine the two conditions in Excel.
Thanks.
statements that I would like to combine. The first counts the number of
logins based on the time of day. There are three different statements.
=COUNTIF('LC371Logins Unique'!L977:L1013,"<12:00 PM")
=COUNTIFS('LC371Logins Unique'!L977:L1013,">12:00 PM",'LC371Logins
Unique'!L977:L1013,"<4:00 PM")
=COUNTIF('LC371Logins Unique'!L977:L1013,">4:00 PM")
The second counts the number of sessions based on the durration. Again,
there are three different statements.
=COUNTIF('LC371Logins Unique'!$O$2:O1265,"<0:15")-COUNTIF('LC371Logins
Unique'!$O$977:O1036,"<0:15")
=COUNTIF('LC371Logins Unique'!$O$2:O1265,">=0:15")-COUNTIF('LC371Logins
Unique'!$O$2:O1265,">0:35")
=COUNTIF('LC371Logins Unique'!$O$2:O1265,">0:35")
What I need to know is how many sessions are less than 15 minutes before
12:00 pm, between 12:00 and 4:00 pm, and after 4:00 pm. This then needs to
be done for sessions between 15 and 35 minutes and for sessions over 35
minutes. I will create separate functions for each question.
How would you combine the two conditions into one function? I know in other
programs I would use a WHERE statement for the second condition. How would I
combine the two conditions in Excel.
Thanks.