Hello all,

I need serious help. I have devised a spreadsheet to track the yearly attendance for my students names. Each day for student that are absent i either mark "A" or "E" on the dates corresponding cell. I also mark "T" for tardy. Next to their names i have entered 2 cells one if Total absences =SUM(COUNTIF(E3:HX3,"A")+COUNTIF(E3:HX3,"E") This counts the number of Absences and Excuses absences so i can have a running tally and the other cell is =COUNTIF(F3:HX3,"T") to count all running tardies.

Here is my problem.

On another worksheet i want to do a monthly breakdown of absences to see what each students trend is in terms of absences. My reference worksheet is called Attendance!

How do i do this?

I copied and pasted all of my students names into the new worksheet and made a Sep.,Oct,Nov, columns etc...

What is the fastest way to do this?


Maybe i can email somebody my spreadsheet so they can better understand my dilemma and give me quick advice on what i did wrong.

Another problem i have is that someone can screw with my data by sorting by name and then my total A and total T cells mess up and i have to do it from scratch. Is there something i can do to make all my rows "married" so that if you sort something by accident the whole row gets sorted?

Someone help!