SOLVED

Creating simple attendance chart

Copper Contributor

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

2 Replies
best response confirmed by Smctech (Copper Contributor)
Solution

@Smctech 

Maintaining 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.

@Hans Vogelaar 

 

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.

1 best response

Accepted Solutions
best response confirmed by Smctech (Copper Contributor)
Solution

@Smctech 

Maintaining 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.

View solution in original post