how to use countif function

J

Jon

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!
 
J

JE McGimpsey

With COUNTIF:

E101: =COUNTIF(E7:E84,"<.6") - COUNTIF(E7:E84,"<.5")

Alternatively:

=SUMPRODUCT(--(E7:E84>=0.5),--(E7:E84<0.6))

You might also look at the FREQUENCY() function,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If and Countif 2
If with countif or counta 3
Count Percentages in a range 4
what function to use 4
Not having luck with any examples of averaging... 2
Is there a function to count how many times a cells value is used? 0
Excel - Wich Function should I use? 1
Excel 2007 - Conditional Formatting Problem with Percentages 3

Top