Percentage of passing Scores Formula

[NKlawender]

Hello,
I have a question that I think should be an easy one. I have a column, W, on a spreadsheet that contains test scores. The passing score for the test is a 70. I want to write a formula that will tell me what percentage of the scores are 70 and above. The spreadsheet is constantly added to, so it would need to be easily updated.
Thanks,
Norm

 

[offthelip]

try this:

=COUNTIF(W:W,">=70")/COUNT(W:W)

 

[NKlawender]

Thank you!