Percent of a Spreadsheet Complete
 

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.

Percent of a Spreadsheet Complete
 

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.

Percent of a Spreadsheet Complete
 

Mike,

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

Thanks,

Jenn

"Mike H" wrote:

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.

Percent of a Spreadsheet Complete
 

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.

Percent of a Spreadsheet Complete
 

Your welcome and glad I could help

"Jennifer V." wrote:

Mike,

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

Thanks,

Jenn

"Mike H" wrote:

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.

Percent of a Spreadsheet Complete
 

In C1

=COUNTA(B:B)/COUNTA(A:A)

Format to percentage.


Gord Dibben MS Excel MVP

On Wed, 22 Oct 2008 10:52:00 -0700, 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.

Percent of a Spreadsheet Complete
 

=COUNTA(B1:B400)/COUNTA(A1:A400) and format as percentage.
--
David Biddulph

"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.