Hi Matthew

then try
=COUNTA(C1:C8)/COUNTA(A1:A8)

Regards

Roger Govier


matthewst wrote:
Thanks for the quick reply!

That works to my example, but not for the actual sheet. I get this
error "#DIV/0!". The actual the cells contain names wich that formula
doesn't seem to like. Column A contains names and column C contains
ranks. I need to know the % of people with a rank. The number of people
in column A will change from time to time.
This is a little more difficult than I thought!

In a nutshell:
I need E1 to display the % of cells in column C that contain data as
compared to column A.