I'm trying to create a spreadsheet to keep track of a point total
Here's where it gets tricky, it needs to be simple, and it needs a cell that has a value of say 10, IF it's checked, then that sum sent to a cell for a total, the cell then resets to unchecked, so that every time it's opened the cells appear unchecked, but the total cell still keeps track and adds to the total as necessary, unless someone messes up, there should be no reason to subtract from the total unless manually cleared, each check box can only be checked once per session
Might almost be easier to do in VB, but I haven't touched it in a decade
Here's a rough draft:
Name Event1 Event2 ... Total
Joesnuffy + + 20
Any ideas suggestions, guidance? I have the whole 2010 Office suite but it will then be imported into Google Docs to be embedded into a website


