Countif problem

[weeeee0713]

Hi Everyone,

I'm currently using manual count to get the exact number that meet my condition.
How can I use countif, if the range has a formula. Range column are composed of resulting range <50%, 51%-60%, 61%-70% .... 91%-100%.
Can anyone help me to solve my problem?

Thanks...

[Moo the Dog]

I would think something simple like:

=COUNTIF(my_range,"<=50%") for the first option less than, or equal to 50%, then modify the percentages in the following formula for the rest of the ranges:

=COUNTIFS(my_range,">50%",my_range,"<=60%")

- Moo

[weeeee0713]

Yeah.. I'd did the same thing haha.. Thanks..

[vogel997]

countif-sample.xlsx

try the sample attached.