How to get a count of numbers in a range?

J

JasonD

I have a a series of numbers and I would like to count how many times
range of numbers shows up. For example if you have: 100 102 205 21
108 178 188 212

I would like to know how many times a number in the 200s shows up. I
this list the answer should be (3). 205, 215, and 212.

Is this possible? and if so how?

Thanks in advance,
Jaso
 
N

NH

Assuming A1:A4 hods the data
=SUMPRODUCT(--(A1:A4>199),--(A1:A4<300))
Press Ctrl-Shift-Enter after entering the above formula
 
Top