Hi Jose,

If I understand the question correctly you need to count the number of c'c
or n's and divide by the sum of the c's and n's and then format the cell with
the formula to percentage.

Assume that the c' and n's are in cells A1:A50 then like this for percentage
of c's

=COUNTIF(A1:A50,"c") / (COUNTIF(A1:A50,"c")+COUNTIF(A1:A50,"n"))

Like this for percentage of n's

=COUNTIF(A1:A50,"n")/(COUNTIF(A1:A50,"c")+COUNTIF(A1:A50,"n"))


--
Regards,

OssieMac


"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.