Countif function and finding percentage

Question

ihave a column of data with numbers ranging from 1 - 12 in that column.  i want to know how to find the percentage of times a number is = or < 5 out of the whole collection of data.

so below is my collection of data.  there are 10 numbers.  3 of those numbers are =/< 5.  thus, 3 out of 10 = 30%.  How do i write this in a formula for a cell??  Thanx for your help!!  --4max

Answer 1

Hi,

Try this and format as %

=COUNTIF(A1:A10,"<="&5)/COUNT(A1:A10)

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 2

Why not the non-array

=COUNTIF(A1:A10,"<=5")/COUNT(A1:A10)

--

HTH

Bob

<Bernd Pl> wrote in message news:*** Email address is removed for privacy ***...

One way:

Array-enter

=COUNT(IF(A1:A10<=5,1))/COUNT(A1:A10)

Regards,

Bernd

---

http://www.sulprobil.com/html/excel_forums.html

Answer 3

Your welcome and thanks for the feedback

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 4

Great!  thx!

Answer 5

One way:

Array-enter

=COUNT(IF(A1:A10<=5,1))/COUNT(A1:A10)

Regards,

Bernd

---

http://www.sulprobil.com/html/excel_forums.html