Jun 04 2021 11:06 AM
Hello all and Thank You in advance for any help provided.
I am trying to create a simple attendance tracking sheet. The full details of what I want it to do are as follows:
The meeting/event happens once weekly and the worksheet will track yearly.
The sheet will track if a user did or did not attend the meeting/event ( I would prefer a simple checkbox that centers and resizes with the cell for the date ).
If an attendee does attend then it will be worth points and need a formula to sum the number of attendances and multiply that by point value to get total points accrued.
I have searched through templates but what I have found are more advanced or limited to one person and when I try to edit creates errors
Attached is what I have so far.
I am using Up to Date Win 10 and Office 365-Excel
Thank you again for any help
Jun 04 2021 11:55 AM
SolutionMaintaining hundreds of check boxes would be a PITA. I'd keep it simple and enter something like an "x" in a cell to indicate attendance.
See the attached version.
Jun 04 2021 12:09 PM
Thank you very much this will be quite helpful. I hadn't thought of using "COUNTA" formula.
I still have a bunch of formatting to do but this will be a great start.
Jun 04 2021 11:55 AM
SolutionMaintaining hundreds of check boxes would be a PITA. I'd keep it simple and enter something like an "x" in a cell to indicate attendance.
See the attached version.