Try this in C1, format as %

=COUNTA(B1:B400)/COUNTA(A1:A400)

Mike

"Jennifer V." wrote:

I have a list of data (text approx 400 rows Column A) that I am validating.
If they are valid, I am writing a summary note in Column B. I want to know
(let's say in Cell C1) what percentage of the sheet I have completed. I know
there is a way to do this, but I cannot remember how.

Thanks,

Jennifer V.