I have a register where I have to Insert a "1" if student is present and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King