SOLVED

Creating simple attendance chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2417287%22%20slang%3D%22en-US%22%3ECreating%20simple%20attendance%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2417287%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%20and%20Thank%20You%20in%20advance%20for%20any%20help%20provided.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20simple%20attendance%20tracking%20sheet.%20The%20full%20details%20of%20what%20I%20want%20it%20to%20do%20are%20as%20follows%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20meeting%2Fevent%20happens%20once%20weekly%20and%20the%20worksheet%20will%20track%20yearly.%3C%2FP%3E%3CP%3EThe%20sheet%20will%20track%20if%20a%20user%20did%20or%20did%20not%20attend%20the%20meeting%2Fevent%20(%20I%20would%20prefer%20a%20simple%20checkbox%20that%20centers%20and%20resizes%20with%20the%20cell%20for%20the%20date%20).%3C%2FP%3E%3CP%3EIf%20an%20attendee%20does%20attend%20then%20it%20will%20be%20worth%20points%20and%20need%20a%20formula%20to%20sum%20the%20number%20of%20attendances%20and%20multiply%20that%20by%20point%20value%20to%20get%20total%20points%20accrued.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20searched%20through%20templates%20but%20what%20I%20have%20found%20are%20more%20advanced%20or%20limited%20to%20one%20person%20and%20when%20I%20try%20to%20edit%20creates%20errors%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20what%20I%20have%20so%20far.%3C%2FP%3E%3CP%3EI%20am%20using%20Up%20to%20Date%20Win%2010%20and%20Office%20365-Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20again%20for%20any%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2417287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2417458%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20simple%20attendance%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2417458%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1071341%22%20target%3D%22_blank%22%3E%40Smctech%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMaintaining%20hundreds%20of%20check%20boxes%20would%20be%20a%20PITA.%20I'd%20keep%20it%20simple%20and%20enter%20something%20like%20an%20%22x%22%20in%20a%20cell%20to%20indicate%20attendance.%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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.