I am setting up a spreadsheet to keep track of my students. I want to use
excel if possible to keep track of lates, left early, attendance, etc, as my
grades are kept there already. I was wondering if you can assign values to
variables to accomplish this and how to define them.
Thanks

Why do you want to assign to variables, why not just use worksheet cells?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I am setting up a spreadsheet to keep track of my students. I want to use
excel if possible to keep track of lates, left early, attendance, etc, as
my
grades are kept there already. I was wondering if you can assign values
to
variables to accomplish this and how to define them.
Thanks

I have several sheets with grades, assignments, etc, that I use the info from
for my midterm report and the final report. On the final report we now have
to include how many days absent, late, or left early. Each late or left
early counts as 1/3 of a day missed (every three count as an absence), I need
to list how many times they left early, were late, or were absent separately
on my final cover sheet.

"Bob Phillips" wrote:

Why do you want to assign to variables, why not just use worksheet cells?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I am setting up a spreadsheet to keep track of my students. I want to use
excel if possible to keep track of lates, left early, attendance, etc, as
my
grades are kept there already. I was wondering if you can assign values
to
variables to accomplish this and how to define them.
Thanks

But that is exactly what formulas and functions are for, and can easily
achieve, without variables.You just need to design the spreadsheets to
accumulate/aggregate/analyse the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I have several sheets with grades, assignments, etc, that I use the info
from
for my midterm report and the final report. On the final report we now
have
to include how many days absent, late, or left early. Each late or left
early counts as 1/3 of a day missed (every three count as an absence), I
need
to list how many times they left early, were late, or were absent
separately
on my final cover sheet.

"Bob Phillips" wrote:

Why do you want to assign to variables, why not just use worksheet
cells?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I am setting up a spreadsheet to keep track of my students. I want to
use
excel if possible to keep track of lates, left early, attendance, etc,
as
my
grades are kept there already. I was wondering if you can assign
values
to
variables to accomplish this and how to define them.
Thanks

I see, I guess I am not sure how to tranlate the Lates, Absences, and Left
early entries to track them. I sn't seem to get countif to work to count
them, is there another way?


"Bob Phillips" wrote:

But that is exactly what formulas and functions are for, and can easily
achieve, without variables.You just need to design the spreadsheets to
accumulate/aggregate/analyse the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I have several sheets with grades, assignments, etc, that I use the info
from
for my midterm report and the final report. On the final report we now
have
to include how many days absent, late, or left early. Each late or left
early counts as 1/3 of a day missed (every three count as an absence), I
need
to list how many times they left early, were late, or were absent
separately
on my final cover sheet.

"Bob Phillips" wrote:

Why do you want to assign to variables, why not just use worksheet
cells?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I am setting up a spreadsheet to keep track of my students. I want to
use
excel if possible to keep track of lates, left early, attendance, etc,
as
my
grades are kept there already. I was wondering if you can assign
values
to
variables to accomplish this and how to define them.
Thanks

It is a bit difficult as I don't know how you have structured your data, but
as an example, if you use the letter 'l' for a lateness in D1:D100, you can
add this to the absence count

=SUMPRODUCT(--(D1:D100="l"))/3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I see, I guess I am not sure how to tranlate the Lates, Absences, and Left
early entries to track them. I sn't seem to get countif to work to count
them, is there another way?


"Bob Phillips" wrote:

But that is exactly what formulas and functions are for, and can easily
achieve, without variables.You just need to design the spreadsheets to
accumulate/aggregate/analyse the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I have several sheets with grades, assignments, etc, that I use the
info
from
for my midterm report and the final report. On the final report we
now
have
to include how many days absent, late, or left early. Each late or
left
early counts as 1/3 of a day missed (every three count as an absence),
I
need
to list how many times they left early, were late, or were absent
separately
on my final cover sheet.

"Bob Phillips" wrote:

Why do you want to assign to variables, why not just use worksheet
cells?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I am setting up a spreadsheet to keep track of my students. I
want to
use
excel if possible to keep track of lates, left early, attendance,
etc,
as
my
grades are kept there already. I was wondering if you can assign
values
to
variables to accomplish this and how to define them.
Thanks

I appreciate all your help. That worked fine. I used the countif to keep
track as with the formula similar to below. It works now.

"Bob Phillips" wrote:

It is a bit difficult as I don't know how you have structured your data, but
as an example, if you use the letter 'l' for a lateness in D1:D100, you can
add this to the absence count

=SUMPRODUCT(--(D1:D100="l"))/3

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I see, I guess I am not sure how to tranlate the Lates, Absences, and Left
early entries to track them. I sn't seem to get countif to work to count
them, is there another way?


"Bob Phillips" wrote:

But that is exactly what formulas and functions are for, and can easily
achieve, without variables.You just need to design the spreadsheets to
accumulate/aggregate/analyse the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I have several sheets with grades, assignments, etc, that I use the
info
from
for my midterm report and the final report. On the final report we
now
have
to include how many days absent, late, or left early. Each late or
left
early counts as 1/3 of a day missed (every three count as an absence),
I
need
to list how many times they left early, were late, or were absent
separately
on my final cover sheet.

"Bob Phillips" wrote:

Why do you want to assign to variables, why not just use worksheet
cells?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BigRon" wrote in message
...
I am setting up a spreadsheet to keep track of my students. I
want to
use
excel if possible to keep track of lates, left early, attendance,
etc,
as
my
grades are kept there already. I was wondering if you can assign
values
to
variables to accomplish this and how to define them.
Thanks