Excel 2007 : Students attendance sheet

whil preparing students attendenc sheet how to enter attendenc like 1,2,3 ...

ex:
if a student is present for 1st day clss in 1st colum 1 vl b there ..
if he is absent for 2nd day again 1 i have to get in 2nd colum and on
3rd day if he is present it is his 2nd class so i have to get 2 in 3rd colum
4th day again if he is present 3 ihave 2 get in 4th colum......


.
.
.
.

I M ATTACHING MY REQURIMENT .. WHEN M ENTERING AS STUDENT PRESENT THEN IT HAS TO CALCULATE THE ATTENDED CLASS NUMBER OF THE STUDENT ...

so i want 2 give the attendenc then automatically it has to calculate the class (not even total number of class but daily i want 2 knwo the class number)

I think he just needed the count part, aka =ANTALL(B3:F3) [sorry norwegian version], aka =count(B3:F3) example