Count number > 75% and < 90%

Sassy · Jun 14, 2007

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.

Mike H · Jun 14, 2007

Sassy,

Try

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

Format as general

Mike

Sassy · Jun 14, 2007

Hi Mike,

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

S

Mike H · Jun 14, 2007

Then take a nap now. Thanks for the feedback.

Sassy said:
Hi Mike,

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

S