If then

[JJP]

Hello Everyone,

I am rather new to excel and find it is a very adaptive tool for use in many
ways. I am trying to create a spread sheet that keeps track of students
attendance. I need the spread sheet to inform of students that miss three
days in any given week?
Would this be possible and what is the best way to go about it?

 

[cm]

PLease post example of how your data will look on each row (how you are
tracking 'missed' days.).

 

[EricG]

If you have student names in column A, and let columns B-F be Monday through
Friday, and you mark student attendance by "Y" if they are in attendance that
day or "N" if not, the you could end up with the following table:

A B C D E F
Student Mo Tu We Th Fr
Jimmy Y Y Y N Y
Jane Y N N N Y
John Y Y Y Y Y
Joan N N Y Y Y

In column G in the first cell, put "Absences". In the second cell, enter
this formula:

=COUNTIF(B2:F2,"N")

Then "drag" that cell down for the rest of the list. You should get a
result that looks like the table below.

A B C D E
F G
Student Mo Tu We Th Fr Absences
Jimmy Y Y Y N Y 1
Jane Y N N N Y 3
John Y Y Y Y Y 0
Joan N N Y Y Y 2

Use this example to build your own worksheet for attendance. You could then
use conditional formatting to highlight in bold red font any students that
have three or more absences.

HTH,

Eric

 

[JJP]

Hello CM,

Thank you for responding to my post. How is your evening going? Here is the
example:

Student Name Time Homeroom
Comments



I would enter student name and time. If the student is absent three days out
of the week, they will be assigned an administrative detention.



Would it be able ot

 

[JJP]

Hello EricG,

How are you doing this afternoon and how is your Friday going? Thank you for
responding to my post. Would the suggestions you provided also work with
situation dealing with students being tardy. For example, the names of
students would not be a determined set...the sets will vary from day to day.