How do you define variables in excel?

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" <BigRon@discussions.microsoft.com> wrote in message
news:D246057F-E2D9-474F-85A2-A31440E48142@microsoft.com...
> 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" <BigRon@discussions.microsoft.com> wrote in message
> news:D246057F-E2D9-474F-85A2-A31440E48142@microsoft.com...
> > 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" <BigRon@discussions.microsoft.com> wrote in message
news:8039FEA6-AF4D-46C8-8142-F574D468E4E2@microsoft.com...
> 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" <BigRon@discussions.microsoft.com> wrote in message
> > news:D246057F-E2D9-474F-85A2-A31440E48142@microsoft.com...
> > > 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" <BigRon@discussions.microsoft.com> wrote in message
> news:8039FEA6-AF4D-46C8-8142-F574D468E4E2@microsoft.com...
> > 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" <BigRon@discussions.microsoft.com> wrote in message
> > > news:D246057F-E2D9-474F-85A2-A31440E48142@microsoft.com...
> > > > 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" <BigRon@discussions.microsoft.com> wrote in message
news:BF01C766-9207-40B1-99EE-2982EFAE770E@microsoft.com...
> 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" <BigRon@discussions.microsoft.com> wrote in message
> > news:8039FEA6-AF4D-46C8-8142-F574D468E4E2@microsoft.com...
> > > 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" <BigRon@discussions.microsoft.com> wrote in message
> > > > news:D246057F-E2D9-474F-85A2-A31440E48142@microsoft.com...
> > > > > 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" <BigRon@discussions.microsoft.com> wrote in message
> news:BF01C766-9207-40B1-99EE-2982EFAE770E@microsoft.com...
> > 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" <BigRon@discussions.microsoft.com> wrote in message
> > > news:8039FEA6-AF4D-46C8-8142-F574D468E4E2@microsoft.com...
> > > > 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" <BigRon@discussions.microsoft.com> wrote in message
> > > > > news:D246057F-E2D9-474F-85A2-A31440E48142@microsoft.com...
> > > > > > 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>