how to use countif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=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)
 
Back
Top