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
 
D

Don Guillett

It is NOT necessary to Array enter this formula

--
Don Guillett
SalesAid Software
(e-mail address removed)
NH said:
Assuming A1:A4 hods the data
=SUMPRODUCT(--(A1:A4>199),--(A1:A4<300))
Press Ctrl-Shift-Enter after entering the above formula
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count in a range of numbers 8
how to count maximum number of lines repeated for a site 4
Countif function to show how often numbers within a range are pres 3
Count the frequency for every change in numbers 6
Count Function 1
How do I delete only part of the data in a row of cells? 2
Auto calculate 1
Find the numbers used in a range 4

Top