Finding count of rows within time range

Hi,
I have a list of start and end times and I need to find for each start time, how many other start/end time rows contain this start time.

Data looks like this:
Start End
15:22:35 15:22:40
15:22:35 15:22:53
15:22:37 15:22:50
15:22:37 15:22:50
15:22:38 15:22:43
15:22:38 15:22:41
15:22:38 15:22:41

So you can see for the first row, 15:22:35 is within 2 start-end time ranges (itself and the next row).

Is this possible in Excel please?
Thanks

COUNTIF will do what you need.

=COUNTIF(A:A,A1)

Here, try this:

=SUMPRODUCT(--($A$1:$A$100<=$A1),--($B$1:$B$100>=$A1))

Assuming your data start at A1

Originally Posted by Whizbang

COUNTIF will do what you need.

=COUNTIF(A:A,A1)

Thanks for the prompt response, but this doesn't take into consideration the whole time range (start to end)

Originally Posted by ChemistB

So is 15:22:37 within 4?

Yes.
Actually looking at my data it may be an artifact of the timings only being to the nearest second.

Originally Posted by ChemistB

The sumproduct formula seems to work. Gives 2 for first two rows, then 4 for next two, then 7 for last three. 15:22:38 is in the range of all seven rows. Yes?

Yes I think that's it, thanks zbor!