Am I right in assuming that the formula you gave me works on each column is 1%.

"Marcelo" wrote:

hi,

if my understand is correct I suggest you to use:

1. to see the percentage of the cels completed (with 1,0 or A)
assuming that the FC's are on the C column and the 1,0 or A on the D
put on the end of the D column a formula =counta(d4:d15)/counta(c4:c15)

2. use an altofilter to see the A's, 1's or 0's that you have.

hth
Regaards from Brazil
Marcelo
3.





"fomula problems" escreveu:

I have a worksheet which I would like to be able to use, but dont know how to
put a formula in to give me the info. have tried to enclose a sample hope it
works.
Would like to enter a 1 or 0 or A in the adjacent colum as soon, but would
like to be able to gather and show all 1 or 0 or A with the adjacent cell,
and would like the totaol number of cells to equal 100% when complet but to
be able show the percetage of cells completed. Can someone help me.
FC FC FD FD FE FE
FC002020 1 FD002020 1 FD002020 1
FC002030 FD002030 1 FD003020 1
FC002040 1 FD002040 0 FD004020
FC002050 1 FD002050 1 FD005020 1
FC002060 1 FD002060 1 FD006020 1
FC002070 0 FD002070 1 FD007020 A
FC003020 1 FD003020 A FD003020 1
FC003030 1 FD003030 1 FD003030 1
FC003040 FD003040 1 FD003040 1
FC003050 1 FD003050 1 FD003050
FC003060 0 FD003060 0 FD003060 1
FC003070 1 FD003070 1 FD003070 1