confused305
New Member
- Joined
- Jan 15, 2015
- Messages
- 1
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:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Data to count[/TD]
[TD][/TD]
[TD]Range[/TD]
[TD]Frequency[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]-3 to -1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]17[/TD]
[TD][/TD]
[TD]0 to 2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]3 to 5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]-1[/TD]
[TD][/TD]
[TD]6 to 8[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]9 to 11[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]12 to 14[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]14 to 16[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]17 to 19[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]20 to 21[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
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!!!
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Data to count[/TD]
[TD][/TD]
[TD]Range[/TD]
[TD]Frequency[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]-3 to -1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]17[/TD]
[TD][/TD]
[TD]0 to 2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]3 to 5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]-1[/TD]
[TD][/TD]
[TD]6 to 8[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6[/TD]
[TD][/TD]
[TD]9 to 11[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]12 to 14[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]14 to 16[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]17 to 19[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]20 to 21[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
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!!!