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...
 
Top