Count number 75% and < 90%
 

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.

Count number 75% and < 90%
 

Sassy,

Try

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

Format as general

Mike

"Sassy" wrote:

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.

Count number 75% and < 90%
 

Hi Mike,

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

S

"Mike H" wrote:

Sassy,

Try

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

Format as general

Mike

"Sassy" wrote:

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.

Count number 75% and < 90%
 

Then take a nap now. Thanks for the feedback.

"Sassy" wrote:

Hi Mike,

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

S

"Mike H" wrote:

Sassy,

Try

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

Format as general

Mike

"Sassy" wrote:

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.