Hi,

Here is a formula for % compliance assuming your data is in A2:A100

=COUNTIF(A2:A100,"c")/COUNTA(A2:A100)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jose l." wrote:

ok..i think this is diffucult, I just dont know cause i have never done this.
but i have a spreadsheet that has two columns one says C/N and the other
percent compliance. the c stands for compliant and the n stands for
noncompliant. basically i want the c & n to equal to a percent in the
percent compliance field, so how do i make the c & n be a "number" and then
equal to a percent???? complicated? confused? there are 5 sections of 5 rows
that have 1 percent compliance field.