The formula =COUNT(A:A) will tell how many cells in column A have a value
(date or number)
The formula =COUNTA(B:B) will tell how many cells in B have text
So =COUNTA(B:B)/COUNT(A:A) will give the ration of validated to total
By, being everso helpful, Excel will format this as a date; You need to
format it with the % tool
Note that if you have a heading in B1 you might wish to use
=(COUNTA(B:B)-1)/COUNT(A:A)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jennifer V." wrote in message
...
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.