Cell completion

[Boenerge]

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]

Hi Jason,

You may elaborate a bit on what has to be calculated under what circumstances?...........

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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]

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

 

[RagDyer]

Post the formula you're presently using to calculate the averages.

 

[Boenerge]

The formula is:
=COUNT(D636)/ROWS(D636)
Thanks

 

[Ragdyer]

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.

 

[Boenerge]

Should have thought of that before.
Thanks

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.

 

[Ragdyer]

You're welcome, and appreciate the feed-back.