Count number > 75% and < 90%

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

Guest

I am trying to calculate the number of people that have achieved a % rating
between 75% and 90%. All of the data is in one column. I have tried
countif, this only allows one set of criteria : =COUNTIF(R:R,">90%"), I
cannot get any results with DCOUNT either.
 
Sassy,

Try

=COUNTIF(A:A,"<90%")-(COUNTIF(A:A,"<75%"))

Format as general

Mike
 
Hi Mike,

This works great, thanks Honey Bunny. This left me sleepless last night.

S
 
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

Check to see if cell data is within a range 3
Excel Need Countifs Formula Help 0
COUNTIF....how to use >=0 but <9 as CRITERIA 3
Drop Downs, Index Match or what? 56
CountIF or COUNTA for specific text 6
SUMIF with criteria "<>" & "=" 4
If and Countif 2
need help on either doing a loop and counting specific values orusing subtotal function 2

Back
Top