Im running a scavenger hunt. There are 30 teams and 100 "tasks". each task is assigned a point value based on its difficulty. This make a potential for 3000 task to be completed in a 5 hour span. a potential scoring nightmare.

I am trying to make a spreadsheet that is able to quickly be filled by in each cell not by inputting the number, but to have the value of that task be able to be simply filled by typing a single letter X into the cell and having that letter have a defined value for each column. Instead of constantly going back to reference the value of each task, it could be formulated in prior and once we mark that one of the team has completed this task it would fill with the number.

example; task #1 is worth 250 points. I there a formula or way to do this??

Thank you in advance for any help. I hope this question makes sense.

`SUMIF`

could do the job. This would be easier to answer in more detail if we could see sample data – cybernetic.nomad Jan 10 at 22:21