Thread: Describe high/low range with CountIf (ex. count if >90 and <100
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default
One way:

=COUNTIF(A:A,"90") - COUNTIF(A:A, "=100")

Another:

=SUMPRODUCT(--(A1:A1000<90),--(A1:A1000<100))
Reply With QuoteReply With Quote