Excel illiterate: frequency for intervals

I am illiterate in excel, sorry if my question seems stupid:

I am dealing with intervals: A1 = max value of set interval; B1 = min value of set interval

A B
1 7051 6770
2 6654 6462
3 6459 6253
4 6684 6469
5 6439 6253
6 5720 5513
7 5838 5623

I am looking for a formula to calculate the frequency of intervals that fall within a 500-mark range; In effect, the same interval would count more than once:

The frequency in this case would be (if my calculations are right)
7500-7000: 1

7000-6500: 3

6500-6000: 4

6000-5500: 2



Thank you in advance for any suggestion!

xi

Can you explain how you arrived at those answers?

MAX MIN Interval Count
7051 6770 5000 =FREQUENCY($A$2:$B$9,D2) =E2
6654 6462 =D2+500 =FREQUENCY($A$2:$B$9,D3) =E3-E2
6459 6253 =D3+500 =FREQUENCY($A$2:$B$9,D4) =E4-E3
6684 6469 =D4+500 =FREQUENCY($A$2:$B$9,D5) =E5-E4
6439 6253 =D5+500 =FREQUENCY($A$2:$B$9,D6) =E6-E5
5720 5513 =D6+500 =FREQUENCY($A$2:$B$9,D7) =E7-E6
5838 5623 =D7+500 =FREQUENCY($A$2:$B$9,D8) =E8-E7
5838 5623 =D8+500 =FREQUENCY($A$2:$B$9,D9) =E9-E8

Ah, that's what he meant.

	A	B	C	D	E	F
1	7051	6770		5500	0	E1:E6: {=FREQUENCY(A1:B7, D1:D5)}
2	6654	6462		6000	4
3	6459	6253		6500	6
4	6684	6469		7000	3
5	6439	6253		7500	1
6	5720	5513			0
7	5838	5623

Enter the values shown in D1:D5. Then select E1:E6, paste

=FREQUENCY(A1:B7, D1:D5)

... in the formula bar, then press and hold the Ctrl and Shift keys, then press Enter.

	A	B	C	D	E	F	G
1	Max	Min		Max	Min	Overlaps
2	7051	6770		6000	5500	2	F2: =COUNTIFS($A$2:$A$8, ">=" & E2, $B$2:$B$8, "<=" & D2)
3	6654	6462		6500	6000	4
4	6459	6253		7000	6500	3
5	6684	6469		7500	7000	1
6	6439	6253
7	5720	5513
8	5838	5623

You may want to get rid of one or both of the equals signs, depending on how you define "overlap"

You're welcome.