Percent of a Spreadsheet Complete

  • Thread starter Thread starter Jennifer V.
  • Start date Start date
J

Jennifer V.

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.
 
Mike,

You are so smart! I needed to know this ASAP, so you are my hero!

Thanks,

Jenn
 
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
 
Back
Top