Thread: Countif if the value falls between 2 other values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default 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.


Reply With QuoteReply With Quote