Countif (only count if data falls within a range)

[pzamory]

I tried several iterations and I cannot get it to work. I would like to get a count of how many data items fall within a certain range.

For instance, I need a count of how many items have a value between 5 and 15.

Can anyone help?

Thanks

 

[IML]

On 2002-05-03 11:17, pzamory wrote:
I tried several iterations and I cannot get it to work. I would like to get a count of how many data items fall within a certain range.

For instance, I need a count of how many items have a value between 5 and 15.

Can anyone help?

Thanks

did you try

http://www.mrexcel.com/board/viewtopic.php?topic=7197&forum=2

 

[Aladin Akyurek]

On 2002-05-03 11:17, pzamory wrote:
I tried several iterations and I cannot get it to work. I would like to get a count of how many data items fall within a certain range.

For instance, I need a count of how many items have a value between 5 and 15.

Can anyone help?

Thanks

In E1 enter: 5
In E2 enter: 15

When you say between m and n, you need to be specific -- There are 4 possibities:

>= m AND< n
> m AND<= n
> m AND< n [ often called exclusive between ]
>= m AND<= n [ often called inclusive between ]

=COUNTIF(A1:A10,">"&E1)-COUNTIF(A1:A10,">="&E2)

gives you a count based on exclusive between.
This message was edited by Aladin Akyurek on 2002-05-03 11:29

 

[Aladin Akyurek]

did you try

http://www.mrexcel.com/board/viewtopic.php?topic=7197&forum=2


Ian: I didn't realize that it was a repost.