total noob deperate for help working out a formula

[plugy]

I am trying to make a register for my students.
Along the top being the date and student down the side
at the end i have present abcent and late.
I am trying to populate a sum for the month end.
The formula i have used is =COUNTIF(B3:F3,"p")
All date cells selected and if p inserted then it calculates a 1 in the attended cell.
same formula works for absent these are deleted from the total attenadence cell.
Problem comes when i have a cell called late, if i use the same formula it calculates the late but delets the attence figure.
I need it to populate the late cell and the present cell.
If the student has been present 3 days, then attendace cell reads 3, if he has been late the other two occations attendace should be 5, and the late cell 2.
Hope this akes sense.
Any help on the formulas i need to accomplish this will be greatly apprecited.

 

[smpatty08]

I am trying to make a register for my students.
Along the top being the date and student down the side
at the end i have present abcent and late.
I am trying to populate a sum for the month end.
The formula i have used is =COUNTIF(B3:F3,"p")
All date cells selected and if p inserted then it calculates a 1 in the attended cell.
same formula works for absent these are deleted from the total attenadence cell.
Problem comes when i have a cell called late, if i use the same formula it calculates the late but delets the attence figure.
I need it to populate the late cell and the present cell.
If the student has been present 3 days, then attendace cell reads 3, if he has been late the other two occations attendace should be 5, and the late cell 2.
Hope this akes sense.
Any help on the formulas i need to accomplish this will be greatly apprecited.

For Present and on time use;

=COUNTIF(B3:F3,"p")

For Total Attendance use (Counts late);

=SUM(COUNTIF(B3:F3,{"P","L"}))

For Late use;

=COUNTIF(B3:F3,"l")

For Absent use;

=COUNTIF(B3:F3,"a")

I hope this helps.

 

[plugy]

For Present and on time use;

=COUNTIF(B3:F3,"p")

For Total Attendance use (Counts late);

=SUM(COUNTIF(B3:F3,{"P","L"}))

For Late use;

=COUNTIF(B3:F3,"l")

For Absent use;

=COUNTIF(B3:F3,"a")

I hope this helps.

This works great, my next question would be could i just keep extending the dates along the top thus shifting the "in" "out" "late" cells along with it, assume this would make the cells behave not as they should.

Another alternative is i do a seperate sheet for each month, or have one sheet with a drop down of the months and year unsure how to achieve this any ideas?

 

[smpatty08]

Yes, you could add more dates to the top, but you would need to manually change the formulas to include those new cells. I would create a sheet for every month with the students name in Column A starting at A2, then in Row1 starting at B1 put the dates for the month, once you have all that information you can then use the previous formulas to calculate attendance for a single day and you could also calculate every individual student's attendance for the whole month. I think that would be the cleanest way to do it.