How to COUNTIF if Values are Less Than but Greater Than

Question

Ok...&nbsp; Not sure if this has been answered.&nbsp; If I have a set of times; for example, login times.&nbsp; Below is a sample of student login times.&nbsp; The issue I'm running into is finding a formula that works for J6; where anything that is less than J6 but greater than J7 is counted. The scenario I'm trying to capture is a single number that represents how many students have "Good Login Time", Below 30 Minutes Login Time, and None.&nbsp; Am I missing a step or not thinking of this correctly?&nbsp;&nbsp;T400:42:54410:40:01420:20:40430:00:00440:27:22450:42:14460:42:41470:00:00480:22:19490:39:32&nbsp;&nbsp;J5---&gt;0:30:00Good Login Time=COUNTIF(T40:T49,"&gt;="&amp;J5)5J6---&gt;0:29:59Below 30 minutes; more Login Time needed.WHAT IS THE MISSING FORMULA?3J7---&gt;0:00:00No Login Time Recorded=COUNTIF(T40:T49,"="&amp;J7)2&nbsp;

jukapil · Accepted Answer

Lonnie White III&nbsp;use countifs&nbsp;=Countifs(T40:T49,"&lt;"&amp;J5,T40:T49,"&gt;"&amp;J7)

Forum Discussion

How to COUNTIF if Values are Less Than but Greater Than

2 Replies

Resources

	T
40	0:42:54
41	0:40:01
42	0:20:40
43	0:00:00
44	0:27:22
45	0:42:14
46	0:42:41
47	0:00:00
48	0:22:19
49	0:39:32

J5--->	0:30:00	Good Login Time	=COUNTIF(T40:T49,">="&J5)	5
J6--->	0:29:59	Below 30 minutes; more Login Time needed.	WHAT IS THE MISSING FORMULA?	3
J7--->	0:00:00	No Login Time Recorded	=COUNTIF(T40:T49,"="&J7)	2