Calculate percentage

[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

 

[FSt1]

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

adjust ranges and values.

Regards
FSt1

 

[Tony Murray]

Thanks very much. Does the job nicely.

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

adjust ranges and values.

Regards
FSt1

 

[FSt1]

hi
glad to help out. forgot to mention. format to percent.
regards
FSt1