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, 1020) just an example! thanks

=COUNTIF(A1:E1,"10")-COUNTIF(A1:E1,"20")
--
Best Regards,

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


"Buffalo" wrote:

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, 1020) just an example! thanks

On Wed, 3 Dec 2008 13:37:45 -0800, Buffalo
wrote:

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, 1020) just an example! thanks

Try this formula:

=SUMPRODUCT((A1:E110)*(A1:E1<20))

Hope this helps / Lars-Åke

Thank you that worked right away

"Luke M" wrote:

=COUNTIF(A1:E1,"10")-COUNTIF(A1:E1,"20")
--
Best Regards,

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


"Buffalo" wrote:

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, 1020) just an example! thanks

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.

--
Rick (MVP - Excel)


"Luke M" wrote in message ...
=COUNTIF(A1:E1,"10")-COUNTIF(A1:E1,"20")
--
Best Regards,

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


"Buffalo" wrote:

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, 1020) just an example! thanks