Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find percentage of filled cells in one section | Excel Discussion (Misc queries) | |||
how to keep a running tally of boxes filled with info | Excel Worksheet Functions | |||
filled boxes with patterns dont print | Excel Discussion (Misc queries) | |||
Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
Percentage of filled cells | Excel Worksheet Functions |