This is a simplified example of what I am working with. In Excel 2003, say I
have 10 rows of €˜Tasks that include 3 columns of info, Task Name, Date
Completed, and Completed By.

I would like to be able to a cell at the bottom of the spreadsheet that
shows the number of tasks that have been completed as a percentage of the
total number of €˜Completed By fields (10 in this case).

Since the data is text data and not numbers, I wasnt sure how to do this,
but I was hoping there was a relatively easy way for Excel to examine the
contents of the cells in say the €˜Completed By column, and note whether
there was a value in the field or if it is blank, and then give me a
percentage of the €˜Completed By fields that are populated with something,
versus the ones that are still empty. Thus telling me the percent of the
task that are currently complete.

Thanks in advance folks, I great appreciate any adice.

Jim