Calculate percentage

T

Tony Murray

I have a range of figures in a column and I would like to calculate the
percentage of entries that have a value greater than x.

What is the easiest way to do that?

Thanks
Tony
 
F

FSt1

hi
something along this might work.....
=COUNTIF(A1:A10,">5")/COUNT(A1:A10)

adjust ranges and values.

Regards
FSt1
 
T

Tony Murray

Thanks very much. Does the job nicely.

FSt1 said:
hi
something along this might work.....
=COUNTIF(A1:A10,">5")/COUNT(A1:A10)

adjust ranges and values.

Regards
FSt1
Click to expand...
 

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

how can I get a percentage on excel 2002 1
calculating percentage-using rows 4
How do I calculate variance percetage if figures are negative 5
calculate percentage of cells that have any value 6
PERCENTAGE FORMULA 2
Access Group by precinct, calculate percentage of older voters 0
percentage question 6
Percentage remaining 5

Top