Describe high/low range with CountIf (ex. count if >90 and <100

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use two COUNTIF functions. E.g.,

=COUNTIF(A1:A10,"<100")-COUNTIF(A1:A10,"<90")



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Thanks Chip.
really use minus sign between them? Does that serve as an "AND"?
 
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.
Click to expand...

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


--ron
 
Hi,

You may also use array formulas (Ctrl+Shift+Enter) to solve the problem

=sum(if((range>90)*(range<100),1,0))

Regards,

Ashish Mathur
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
COUNTIF....how to use >=0 but <9 as CRITERIA 3
Countif numbers fall between two values 4
If and Countif 2
If with countif or counta 3
COUNTIF Non Contiguous Cells Q 3
Count IF 1
Set up a count and countif? 2

Back
Top