Percentage
Posted by George Grund on February 15, 2001 1:20 PM
Hi,
I'm new to Excel so I hope somebody can help me.
I have a list of 10 names with a value which is a number between 1 and 20. I am trying to find the percentage of the numbers (names) that are within the number 10 (from 1 to 10). Is there a formula or a macro that I can use?
Thank you
Posted by Mark W. on February 15, 2001 1:37 PM
If your values are in column A, use:
=COUNTIF(A:A,"<=10")/COUNT(A:A)
