how to use countif function
 

Hi,
I have a range of cells from E7 to E84
The contents of cells are variety Percentages.
What I want to do is using Count IF function to a count the percentages as
follows:
In E101 I want to a count the percentages which are arranged between 50% and
60%
In E102 between 60% and 70%
70% and 80%
And so on,
Your help is highly appreciated
Thanks!

how to use countif function
 

=COUNTIF(E7:E84,"=50%")-COUNTIF(E7:E84,"=60%")

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jon" wrote in message
...
Hi,
I have a range of cells from E7 to E84
The contents of cells are variety Percentages.
What I want to do is using Count IF function to a count the percentages as
follows:
In E101 I want to a count the percentages which are arranged between 50%
and
60%
In E102 between 60% and 70%
70% and 80%
And so on,
Your help is highly appreciated
Thanks!