Hi Rick
Thank you very very much for your help. A good job it works very well again
a big thank you.
Celtic Charmer ;-)

"Rick Rothstein" wrote:

Okay, label Column BX as appropriate (maybe "Total Elements To Be Completed
by Student" or words to that effect) and place the total elements the
student will be completing in that column (that is, type in 28, 34, or
whatever number of total elements the student is scheduled to do). We will
make Column BY your "Percentage Complete" column (you can label it that if
you wish). Put this formula in BY8 and copy it down to the end of your
student list...

=COUNTA(H8:BW8)/BX8

and use Format/Cells to format those cells in Column BY as Percentage.

--
Rick (MVP - Excel)


"CelticCharmer" wrote in message
...
Hi Rick
yes I can add more columns at the end which will be bx8 onwards as many as
you think I need. Student a is row 8 and not 7 as I have stated sorry.

"Rick Rothstein" wrote:

Having the elements the student plans to do in a location other than the
worksheet (namely, the student's folder) does not help (I can't write a
formula to look into that folder<g). Can you add a column to your
worksheet
and put the total number of elements the student plans to do in it? If
so, I
should be able to give you the formula for the percentage complete that
you
want; if you can't add this column, the you will not be able to do what
you
want.

--
Rick (MVP - Excel)


"CelticCharmer" wrote in
message
...
Hi Rick.
well as i Have them in my work sheet already all 68 elements of them. I
know
the elements the student is doing via his/her learning plan in their
folder,
which we do at the start of the course. I then fill them in as the
student
completes each element.
I put a X into the cells(elements) they are NOT doing and that leaves
blanks
where I will input the dates as they are completed.

"Rick Rothstein" wrote:

Then I need to ask again... how do you know in advance (that means,
BEFORE
they complete ALL of the elements they intend to do) BY LOOKING AT
YOUR
WORKSHEET how many elements the student told you they were going to
do? I
repeat... in order to calculate the percentage that you want, you MUST
know
the number of elements the student will ultimately do so you can
divide
by
it. If that number is not on your worksheet, or cannot be counted in
some
way BEFORE the student completes ALL of his/her elements, then you
cannot
get the percentage complete figure you asked for.

Perhaps if I state my question in a different way, you will see what I
am
looking for. Pretend its the beginning of the school year. You ask
your
students how many elements they plan to do. The next day (second day
of
the
school year), I come up to you while you are looking at the worksheet
and
ask... how many elements did "Student A" tell you they were going to
do?
What would you tell me? Assuming you give me a number... where did you
get
that number from? That number is what I need to know in order to
calculate
the percentage complete.

--
Rick (MVP - Excel)


"CelticCharmer" wrote in
message
...
Hi Rick,
I put the dates in as the student completes each element in the same
row
as
the student is on.

"Rick Rothstein" wrote:

Do you put those dates into the cells when the student tells you
what
elements he/she is going to do (sort of like target dates) and then
do
you
put the actual completion dates in a different row as the student
completes
the element?

--
Rick (MVP - Excel)


"CelticCharmer" wrote in
message
...
Hi Rick
I have all possible elements on my excel sheet from cell columns
h6
to
bw6.
Then the students names go into the cell rows numbers 7, 8,
etc...
So
the
first date input for student 1 will be made in cell h7 and the
last
possible
input will be in cell bw7
I have to have all 68 possible elements because some students may
want
to
different ones.
Maybe I'm trying the impossible?
Thanks for you time,
Celtic Charmer


"Rick Rothstein" wrote:

I know from day one what elements the student will be doing
because they tell me.

And my question is... after they tell you how many elements they
will
be
doing at day one, do you put that information into your
worksheet
anywhere?
If so, tell me where. If not, you will have to; otherwise, you
will
never
be
able to divide by the correct number in order to get a
meaningful
percentage
complete. You can't just use 28 as the divisor for all
situations...
if
the
actually are going to do 34 elements, then when they complete 29
of
them,
using 28 as the divisor would generate a completion percentage
of
more
than
100%.

--
Rick (MVP - Excel)