How can I calculate how often one string appears in a column compared to another string?

Question

I have a column in my Google Docs spreadsheet which contains either "OK" or "NOK" (acceptance testing).

How can I calculate the percentage for how often "OK" appears compared to "NOK".

Answer 1

How about:

= COUNTIF( A1:A100; "OK" ) / COUNT( A1:A100 )

A1:A100 being your range in which the OK/NOK values are defined. If you have more values than OK and NOK, use this:

= COUNTIF( A1:A100; "OK" ) / ( COUNTIF( A1:A100; "OK" ) + COUNTIF( A1:A100; "NOK" ) )

Answer 2

Use this excel formula:

Assuming Column A has list of entries

=(COUNTIF(A:A,"=OK")/COUNTA(A:A))*100