Countif if the value falls between 2 other values
 

Need to count values that fall between two limits: for example
462
997
569
122
Need to count values between 300 and 600.
I can do if my desired value is over or under a target, but not within a
range.
Any help would be greatly appreciated.
Thanks.

Countif if the value falls between 2 other values
 

=COUNTIF(A:A,"=300")-COUNTIF(A:A,"600")


--

Regards,

Peo Sjoblom


"les8" wrote in message
...
Need to count values that fall between two limits: for example
462
997
569
122
Need to count values between 300 and 600.
I can do if my desired value is over or under a target, but not within a
range.
Any help would be greatly appreciated.
Thanks.

Countif if the value falls between 2 other values
 

Try
=SUMPRODUCT(--(A1:A1000=300),--(A1:A1000<=600))
Regards,
Alan.
"les8" wrote in message
...
Need to count values that fall between two limits: for example
462
997
569
122
Need to count values between 300 and 600.
I can do if my desired value is over or under a target, but not within a
range.
Any help would be greatly appreciated.
Thanks.

Countif if the value falls between 2 other values
 

Thanks to both of you. It worked!

"les8" wrote:

Need to count values that fall between two limits: for example
462
997
569
122
Need to count values between 300 and 600.
I can do if my desired value is over or under a target, but not within a
range.
Any help would be greatly appreciated.
Thanks.