Counting Frequency of Numbers in a Column

[confused305]

I'm trying to count the number of values that fall between a range. I would post a picture, but I'm not on my computer with Excel (sorry!!!). But, for example, I would like to get the Frequency column from the Data to count column:

A	B	C	D	E
1	Data to count		Range	Frequency
2	1		-3 to -1	1
3	17		0 to 2	2
4	7		3 to 5	3
5	-1		6 to 8	2
6	6		9 to 11	0
7	8		12 to 14	0
8	0		14 to 16	0
9	5		17 to 19	1
10	5		20 to 21	0

<tbody>
</tbody>

I was thinking of doing a SUMIF formula, but can't quite get it figured out. I also tried two ifs within a sum function, but that seems overly complicated. Can anyone help me out? Sorry if my example was confusing, and let me know if you need any clarifications of my problem. Thanks in advance!!!

 

[njimack]

Sheet1

*	A	B	C	D	E	F
1	Data to count	*	Range	*	*	Frequency
2	1	*	-3	to	-1	1
3	17	*	0	to	2	2
4	7	*	3	to	5	2
5	-1	*	6	to	8	3
6	6	*	9	to	11	0
7	8	*	12	to	14	0
8	0	*	14	to	16	0
9	5	*	17	to	19	1
10	5	*	20	to	21	0

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:21px;"><col style="width:20px;"><col style="width:21px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula F2 =SUMPRODUCT(--($A$2:$A$10>=C2),--($A$2:$A$10<=E2)) F3 =SUMPRODUCT(--($A$2:$A$10>=C3),--($A$2:$A$10<=E3)) F4 =SUMPRODUCT(--($A$2:$A$10>=C4),--($A$2:$A$10<=E4)) F5 =SUMPRODUCT(--($A$2:$A$10>=C5),--($A$2:$A$10<=E5)) F6 =SUMPRODUCT(--($A$2:$A$10>=C6),--($A$2:$A$10<=E6)) F7 =SUMPRODUCT(--($A$2:$A$10>=C7),--($A$2:$A$10<=E7)) F8 =SUMPRODUCT(--($A$2:$A$10>=C8),--($A$2:$A$10<=E8)) F9 =SUMPRODUCT(--($A$2:$A$10>=C9),--($A$2:$A$10<=E9)) F10 =SUMPRODUCT(--($A$2:$A$10>=C10),--($A$2:$A$10<=E10)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4