formula to count how many ranges of values a number fits between

[qwerty2k1]

I've been searching around for a way to do this but have had no luck so far.

Say I have a bunch of ranges of times. The start time is in Column A, and the end time is in Column B. These ranges overlap, often, so I might have:
A B
0 6
4 6
7 11
16 18


I have another column, column C, and I want to see how many of the ranges above the numbers in column C fit into.

So, if I have:
C
1
5
8
10
15

Then I want my outcome to be
D
1
2
1
1
0

Thank you for any help!

 

[barry houdini]

Try using COUNTIFS in column D, e.g. in D2

=COUNTIFS(A$2:A$10,"<="&C2,B$2:B$10,">="&C2)

 

[Jonmo1]

Welcome to the board.
If you have XL2007+ Try

=COUNTIFS(A$1:A$4,"<="&C1,B$1:B$4,">="&C1)

 

[qwerty2k1]

Thank you! I hadn't thought that would keep the adjacent cells in columns A and B paired, but it seems to accomplish that. Is that the work of the $? I'm somewhat familiar with $ in excel but I hadn't thought it would work that way here.