MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)