Counting Numbers

B

Buffalo

I have a list of numbers I want to know how many fall into a certain range.
Is there a way to count them?

EX:

A 12
B 15
C 16
D 2
E 100

now I would like to know how many fall between 10 and 20, is there a
function? something like =countif(A1:E1, 10>20) just an example! thanks
 
L

Lars-Åke Aspelin

I have a list of numbers I want to know how many fall into a certain range.
Is there a way to count them?

EX:

A 12
B 15
C 16
D 2
E 100

now I would like to know how many fall between 10 and 20, is there a
function? something like =countif(A1:E1, 10>20) just an example! thanks

Try this formula:

=SUMPRODUCT((A1:E1>10)*(A1:E1<20))

Hope this helps / Lars-Åke
 
B

Buffalo

Thank you that worked right away

Luke M said:
=COUNTIF(A1:E1,">10")-COUNTIF(A1:E1,">20")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 
R

Rick Rothstein

The last COUNTIF should use >= (greater than or equal) and not just > (greater than)...

=COUNTIF(A1:A6,">10")-COUNTIF(A1:A6,">=20")

otherwise a value of 20 will be counted as being inside the range.
 

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

Top