|  | Cell completion | | |
| | | Boenerge |  |
|  Posted: Fri Jul 11, 2008 5:33 pm Post subject: Cell completion |  |
I have a spreadsheet with cloumns that give a percentage when cells are
completed with a date.
How can I have the cells counted in the percentage if they do not require a
date e.g. if they are not applicable?
Thanks in advance
Jason |
| |
| | | Niek Otten | |
| | Posted: Fri Jul 11, 2008 5:39 pm Post subject: Re: Cell completion | |
Hi Jason,
You may elaborate a bit on what has to be calculated under what circumstances?...........
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message news:A4DF3F29-C1E9-4765-9AE8-749BF45E5792@microsoft.com...
|I have a spreadsheet with cloumns that give a percentage when cells are
| completed with a date.
| How can I have the cells counted in the percentage if they do not require a
| date e.g. if they are not applicable?
| Thanks in advance
| Jason |
| |
| | | Boenerge | |
| | Posted: Fri Jul 11, 2008 5:52 pm Post subject: Re: Cell completion | |
| |  | |
The columns contain dates of when a course has been completed, some people do
not have to complete a particular course so no date is enetered. At the end
of each column a percentage of course completion is calculated. However, as
some people do not have to complete a course and no date is entered then the
percentage never gets to 100%. I wondered if there was anything I could
enter instead of a date but would be counted the same as date so that when
evryone who needs to complete and has then the percentage will reach 100%.
Thanks
Jason
"Niek Otten" wrote:
| Quote: | Hi Jason,
You may elaborate a bit on what has to be calculated under what circumstances?...........
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message news:A4DF3F29-C1E9-4765-9AE8-749BF45E5792@microsoft.com...
|I have a spreadsheet with cloumns that give a percentage when cells are
| completed with a date.
| How can I have the cells counted in the percentage if they do not require a
| date e.g. if they are not applicable?
| Thanks in advance
| Jason
|
|
| |
| | | RagDyer | |
| | Posted: Fri Jul 11, 2008 9:55 pm Post subject: Re: Cell completion | |
| | | |
Post the formula you're presently using to calculate the averages.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:9920D614-5491-4B1C-B4FB-BF095A965851@microsoft.com...
| Quote: | The columns contain dates of when a course has been completed, some people
do
not have to complete a particular course so no date is enetered. At the
end
of each column a percentage of course completion is calculated. However,
as
some people do not have to complete a course and no date is entered then
the
percentage never gets to 100%. I wondered if there was anything I could
enter instead of a date but would be counted the same as date so that when
evryone who needs to complete and has then the percentage will reach 100%.
Thanks
Jason
"Niek Otten" wrote:
Hi Jason,
You may elaborate a bit on what has to be calculated under what
circumstances?...........
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:A4DF3F29-C1E9-4765-9AE8-749BF45E5792@microsoft.com...
|I have a spreadsheet with cloumns that give a percentage when cells are
| completed with a date.
| How can I have the cells counted in the percentage if they do not
require a
| date e.g. if they are not applicable?
| Thanks in advance
| Jason
|
|
| |
| | | Boenerge | |
| | Posted: Sat Jul 12, 2008 7:53 am Post subject: Re: Cell completion | |
| | | |
The formula is:
=COUNT(D6:D36)/ROWS(D6:D36)
Thanks
"Boenerge" wrote:
| Quote: | The columns contain dates of when a course has been completed, some people do
not have to complete a particular course so no date is enetered. At the end
of each column a percentage of course completion is calculated. However, as
some people do not have to complete a course and no date is entered then the
percentage never gets to 100%. I wondered if there was anything I could
enter instead of a date but would be counted the same as date so that when
evryone who needs to complete and has then the percentage will reach 100%.
Thanks
Jason
"Niek Otten" wrote:
Hi Jason,
You may elaborate a bit on what has to be calculated under what circumstances?...........
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message news:A4DF3F29-C1E9-4765-9AE8-749BF45E5792@microsoft.com...
|I have a spreadsheet with cloumns that give a percentage when cells are
| completed with a date.
| How can I have the cells counted in the percentage if they do not require a
| date e.g. if they are not applicable?
| Thanks in advance
| Jason
|
|
| |
| | | Ragdyer | |
| | Posted: Sat Jul 12, 2008 2:22 pm Post subject: Re: Cell completion | |
| | | |
All you're doing is calculating the percent of the range that's populated
with numbers (dates).
So, just enter 0's for those situations.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:D6978EB4-0060-4EE8-AD98-6966E0A09A4E@microsoft.com...
| Quote: | The formula is:
=COUNT(D6:D36)/ROWS(D6:D36)
Thanks
"Boenerge" wrote:
The columns contain dates of when a course has been completed, some
people do
not have to complete a particular course so no date is enetered. At the
end
of each column a percentage of course completion is calculated.
However, as
some people do not have to complete a course and no date is entered then
the
percentage never gets to 100%. I wondered if there was anything I could
enter instead of a date but would be counted the same as date so that
when
evryone who needs to complete and has then the percentage will reach
100%.
Thanks
Jason
"Niek Otten" wrote:
Hi Jason,
You may elaborate a bit on what has to be calculated under what
circumstances?...........
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:A4DF3F29-C1E9-4765-9AE8-749BF45E5792@microsoft.com...
|I have a spreadsheet with cloumns that give a percentage when cells
are
| completed with a date.
| How can I have the cells counted in the percentage if they do not
require a
| date e.g. if they are not applicable?
| Thanks in advance
| Jason
|
|
| |
| | | Boenerge | |
| | Posted: Sat Jul 12, 2008 3:49 pm Post subject: Re: Cell completion | |
| | | |
Should have thought of that before.
Thanks
"Ragdyer" wrote:
| Quote: | All you're doing is calculating the percent of the range that's populated
with numbers (dates).
So, just enter 0's for those situations.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:D6978EB4-0060-4EE8-AD98-6966E0A09A4E@microsoft.com...
The formula is:
=COUNT(D6:D36)/ROWS(D6:D36)
Thanks
"Boenerge" wrote:
The columns contain dates of when a course has been completed, some
people do
not have to complete a particular course so no date is enetered. At the
end
of each column a percentage of course completion is calculated.
However, as
some people do not have to complete a course and no date is entered then
the
percentage never gets to 100%. I wondered if there was anything I could
enter instead of a date but would be counted the same as date so that
when
evryone who needs to complete and has then the percentage will reach
100%.
Thanks
Jason
"Niek Otten" wrote:
Hi Jason,
You may elaborate a bit on what has to be calculated under what
circumstances?...........
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:A4DF3F29-C1E9-4765-9AE8-749BF45E5792@microsoft.com...
|I have a spreadsheet with cloumns that give a percentage when cells
are
| completed with a date.
| How can I have the cells counted in the percentage if they do not
require a
| date e.g. if they are not applicable?
| Thanks in advance
| Jason
|
|
| |
| | | Ragdyer | |
| | Posted: Sat Jul 12, 2008 4:31 pm Post subject: Re: Cell completion | |
| | | |
You're welcome, and appreciate the feed-back.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:9A8FCF47-CB4E-4971-8FC6-755B490D41F7@microsoft.com...
| Quote: | Should have thought of that before.
Thanks
"Ragdyer" wrote:
All you're doing is calculating the percent of the range that's
populated
with numbers (dates).
So, just enter 0's for those situations.
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:D6978EB4-0060-4EE8-AD98-6966E0A09A4E@microsoft.com...
The formula is:
=COUNT(D6:D36)/ROWS(D6:D36)
Thanks
"Boenerge" wrote:
The columns contain dates of when a course has been completed, some
people do
not have to complete a particular course so no date is enetered. At
the
end
of each column a percentage of course completion is calculated.
However, as
some people do not have to complete a course and no date is entered
then
the
percentage never gets to 100%. I wondered if there was anything I
could
enter instead of a date but would be counted the same as date so
that
when
evryone who needs to complete and has then the percentage will reach
100%.
Thanks
Jason
"Niek Otten" wrote:
Hi Jason,
You may elaborate a bit on what has to be calculated under what
circumstances?...........
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:A4DF3F29-C1E9-4765-9AE8-749BF45E5792@microsoft.com...
|I have a spreadsheet with cloumns that give a percentage when
cells
are
| completed with a date.
| How can I have the cells counted in the percentage if they do
not
require a
| date e.g. if they are not applicable?
| Thanks in advance
| Jason
|
|
| |
|
|
