Count number > 75% and < 90%

[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.

 

[Guest]

Sassy,

Try

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

Format as general

Mike

 

[Guest]

Hi Mike,

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

S

 

[Guest]

Then take a nap now. Thanks for the feedback.

Hi Mike,

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

S