Percentage of filled in boxes in a column formula

  • Thread starter Thread starter fireman175
  • Start date Start date
F

fireman175

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.
 
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
 
fireman175 said:
I tried that, but it just gave me date of 1/0/0. Any other ideas
Click to expand...

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 Format>Cells)? 0%?

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