calculating an ongoing percentage

  • Thread starter Thread starter judoist
  • Start date Start date
J

judoist

I'd like to add a column to my database which will contain single digit
and blank spaces.

Does anyone know how to set up an ongoing percentage calculation t
compare the number of digits in the column with total number of cell
in that column.

eg.
Cell 1 contains 5, percentage= 100
Cell 2 contains 8, = 100
Cell 3 is blank, = 66.6%

Thank
 
One way:

If you want your calculation to occur in one cell only:

Array-enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=COUNTA(A1:A65535)/MAX(ROW(1:65535)*(A1:A65535<>""))

Format as a percentage.

If instead you want a calculation in each row:

B1: =COUNTA(A$1:A1)/ROW()

Copy down as far as desired.
 
Back
Top