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.