Thread: Describe high/low range with CountIf (ex. count if >90 and <100
View Single Post
  #5   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default
On Sun, 18 Sep 2005 12:49:01 -0700, "jsky"
wrote:

how can I use the COUNTIF formula to count only those numbers that fit
between a range like greater than 90 but less than 100.

=COUNTIF(rng,"90") - COUNTIF(rng,"=100")


--ron
Reply With QuoteReply With Quote