-1

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.

  • 1
    The answer to your question ("Is there a formula or way to do this?") is "yes". It's likely a 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
1

Here are two ways to go about it:

Method 1: Use the following formula:

=SUMIF(C$2:C$8,"x",$B$2:$B$8)

and populate across the bottom of the table

Method 2: Use this formula:

=SUM($B$2:$B$8)-SUMIF(C$2:C$8,"",$B$2:$B$8)

enter image description here

(you'll notice method 1 only counts a score if you've entered an x in the cells, whereas method 2 allows for typos (see cell F7))

  • Thank you so much! This will make the day fun for everyone (including the scorekeepers) – shawnO Jan 10 at 22:39

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.