Several worksheet tally by name

[Guest]

I have a worksheet that has several layers:
Tardy, Absent, Jan, Feb, Mar, Apr etc., etc.
I have the employees listed on the first two with a reference of their
initials:
Smith, Robert (RS)
On each of the individual months I have noted (RS) for each day absent or
tardy, separating each employee if more than one are tardy on any given day
by a comma: (RS), (PG) etc., etc.

I can't seem to figure out how to keep a running tally of tardy and absent?
Thanks in advance!

 

[Guest]

So long as you use that structure you'll have nothing but heartache and errors

Just use one column for the date (not the month), another column for the
employee, and a 3d column for T(ardy) or A(bsent)

If more than one is absent or tardy on the same date, put the date in as
many times as needed for each event. In other words, if 3 are absent/tardy
on May 12, enter May 12 three times, once for each employee

Then you can create Pivot tables or use simple formulas for what you want.