I'm doing my club's accounting in a Google spreadsheet. I am looking for a way to put a checkbox at the beginning of a line in order to tick off the members who paid their dues and then have a function that will automatically add the amount of the "dues paid" cell to a "total dues paid" cell, elsewhere in the sheet.
Right now I'm doing it with a function of the type
SUM(A1:A600)-A3-A20-A120 etc.—not very elegant…
If anyone could point me to a solution or a resource to learn how to implement this, I would appreciate it!