Percentage database help

[simjambra]

Hi there...

I have a list that I need to evaluate and calculate a percentage of records based on criteria...

e.g.

say this was my list:


Name Age Height
Simon 28 65
Bob 35 64
Jim 37 66

I would like to find out the percentage of people older than 30... in this case 66.6%

Is there a database function or something I could use to perform this calculation?

Thanks

Simon

[arthurbr]

Hi and welcome to the board

Try the following :

=COUNTIF(A1:A3;">30")/COUNT(A1:A3)

Adjust the range to fit and replace ; with , if needed

Cheers

[simjambra]

Works a treat.

Cheers fella

[arthurbr]

You're welcome and thx for the feedback