Check to see if cell data is within a range

  • Thread starter Thread starter mwrfsu
  • Start date Start date
M

mwrfsu

I want to count the number of cells with in a range that fall between
certain range. I can get it to work with one criteria but not whe
adding the second.

For example, I want to count the number of cells between I8:I24 tha
are >= 75 but < 90.

This works for greater than 75 but not sure what to do for the les
than 90.
=COUNTIF(FIN!$I$8:$I$24,">=.75")

Thank you for any help
 
This technique can be adapted to any combination of conditions.

Consider the formula

=(I8>=75)*(I8<90)

It returns 1 for the numbers you want to count and 0 otherwise. Enter this
in a column to the right of I and copy down. The sum of the 1's is what you
want.
 
2 ways

=countif(I8:I24,"<90")-=countif(I8:I24,"<=75")

=SUMPRODUCT(--(I8:I24<90),--(I8:I24,<=75))
 

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
SUMIF data that falls within a range 3
COUNTIF Cells in Range? 4
Excel - count if a number falls within an array in a column & add 3
subtract one cell from each cell in a range and count instances 2
If statement based on time ranges 2
Count time formatted data within range 1
Count range of cells if not next to each other 0

Back
Top