Percentage of filled in boxes in a column formula
 

Hi, I have a few columns with about 150 rows broken into say 5 sections (30
rows each). I enter a date in each box as a procedure is completed. I would
like to keep a tally of the percentage of completion for each column. So,
each time I enter a date in the 150 rows, the percentage of filled in boxes
increases.

Thank you in advance.

Percentage of filled in boxes in a column formula
 

Since real dates are numbers, something simple like this,
placed in say E1: =COUNT(A1:A30)/30
with E1 formatted as percentage to taste
should yield what you're after

Adapt/extend to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"fireman175" wrote:
Hi, I have a few columns with about 150 rows broken into say 5 sections (30
rows each). I enter a date in each box as a procedure is completed. I would
like to keep a tally of the percentage of completion for each column. So,
each time I enter a date in the 150 rows, the percentage of filled in boxes
increases.

Thank you in advance.

Percentage of filled in boxes in a column formula
 

I tried that, but it just gave me date of 1/0/0. Any other ideas?

"Max" wrote:

Since real dates are numbers, something simple like this,
placed in say E1: =COUNT(A1:A30)/30
with E1 formatted as percentage to taste
should yield what you're after

Adapt/extend to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"fireman175" wrote:
Hi, I have a few columns with about 150 rows broken into say 5 sections (30
rows each). I enter a date in each box as a procedure is completed. I would
like to keep a tally of the percentage of completion for each column. So,
each time I enter a date in the 150 rows, the percentage of filled in boxes
increases.

Thank you in advance.

Percentage of filled in boxes in a column formula
 

"fireman175" wrote:
I tried that, but it just gave me date of 1/0/0. Any other ideas

No reason why it should not work. As mentioned in my response, I presumed
you are entering *real* dates within A1:A30. What is displayed when you
format that formula cell as percentage (under FormatCells)? 0%?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Percentage of filled in boxes in a column formula
 

Ahhh, that was the missing link. I changed that cell to percentage and it
works great. Thanks alot for your knowledge. I learn alot from people like
you helping us out.

"Max" wrote:

"fireman175" wrote:
I tried that, but it just gave me date of 1/0/0. Any other ideas

No reason why it should not work. As mentioned in my response, I presumed
you are entering *real* dates within A1:A30. What is displayed when you
format that formula cell as percentage (under FormatCells)? 0%?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Percentage of filled in boxes in a column formula
 

No prob, you're welcome. Pl take a moment to press the "Yes" button below.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"fireman175" wrote:
Ahhh, that was the missing link. I changed that cell to percentage and it
works great. Thanks alot for your knowledge. I learn alot from people like
you helping us out.