CountIfs Time Stamps

[JCDCP123]

Hi all,

Having trouble with a CountIfs function.

I am trying to answer the question: At any given time (down to the second), how many people were in attendance at our online course?

My spreadsheet looks like this:

A	B	C	D	E	F
SessionStart	SessionEnd		Concurrent Viewers
7:00:00 PM​	7:02:17 PM​		Time 1	Time 2	Count
7:00:00 PM​	7:02:10 PM​		7:00:00 PM​	7:00:01 PM​	0​
7:00:00 PM​	7:07:34 PM​		7:00:01 PM​	7:00:02 PM​	0​
7:00:00 PM​	7:07:19 PM​		7:00:02 PM​	7:00:03 PM​	0​
7:00:00 PM​	7:07:25 PM​		7:00:03 PM​	7:00:04 PM​	0​
7:00:00 PM​	7:03:12 PM​		7:00:04 PM​	7:00:05 PM​	0​
7:16:00 PM​	8:00:00 PM​		7:00:05 PM​	7:00:06 PM​	0​
7:16:04 PM​	7:16:11 PM​		7:00:06 PM​	7:00:07 PM​	0​

And the formula in Column F is:
=COUNTIFS(A:A,"=<"&D3,B:B,">"&E3)

Unfortunately, as you can see, it's returning a value of 0 in all cells.

All the cells with timestamps are formatted as Time only. There is no date data included in there (as far as I can tell).

Does anyone know how I could fix this?
Thanks in advance.

 

[jtakw]

Hi,

You have the "=<" backwards, should be:

=COUNTIFS(A:A,"<="&D3,B:B,">"&E3)

 

[JCDCP123]

Ah, silly me! Thanks so much @

Hi,

You have the "=<" backwards, should be:

=COUNTIFS(A:A,"<="&D3,B:B,">"&E3)

Ah, silly me! Thanks so mcuh @jtakw .

 

[jtakw]

You're welcome, glad to help.

PS: you're supposed to mark the post that gave you the answer as solution, marking your own post as solution flags it with the MODs, unless you answered your own question.

 

[smozgur]

@JCDCP123 - I just switched the marked solution with the correct one that you also confirmed. Next time, that would be great if you could mark the solution post that answered the problem instead of your final post. It will help future readers to find the solution post easier.