Excel spreadsheet, is there a way to have a easily inputted value such as the letter x to denote a certain...
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.
microsoft-excel worksheet-function
asked Jan 10 at 22:14
shawnOshawnO
11
add a comment |
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.
microsoft-excel worksheet-function
asked Jan 10 at 22:14
shawnOshawnO
11
1
The answer to your question ("Is there a formula or way to do this?") is "yes". It's likely aSUMIFcould 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
add a comment |
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.
microsoft-excel worksheet-function
asked Jan 10 at 22:14
shawnOshawnO
11
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.
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked Jan 10 at 22:14
shawnOshawnO
11
asked Jan 10 at 22:14
shawnOshawnO
11
asked Jan 10 at 22:14
shawnOshawnO
11
asked Jan 10 at 22:14
shawnOshawnO
11
asked Jan 10 at 22:14
shawnOshawnO
11
11
1
The answer to your question ("Is there a formula or way to do this?") is "yes". It's likely aSUMIFcould 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
add a comment |
1
The answer to your question ("Is there a formula or way to do this?") is "yes". It's likely aSUMIFcould 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
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
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
add a comment |
1 Answer
1
active
oldest
votes
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)
(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))
answered Jan 10 at 22:32
cybernetic.nomadcybernetic.nomad
1,692212
Thank you so much! This will make the day fun for everyone (including the scorekeepers)
– shawnO
Jan 10 at 22:39
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1392949%2fexcel-spreadsheet-is-there-a-way-to-have-a-easily-inputted-value-such-as-the-le%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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)
(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))
answered Jan 10 at 22:32
cybernetic.nomadcybernetic.nomad
1,692212
Thank you so much! This will make the day fun for everyone (including the scorekeepers)
– shawnO
Jan 10 at 22:39
add a comment |
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)
(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))
answered Jan 10 at 22:32
cybernetic.nomadcybernetic.nomad
1,692212
Thank you so much! This will make the day fun for everyone (including the scorekeepers)
– shawnO
Jan 10 at 22:39
add a comment |
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)
(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))
answered Jan 10 at 22:32
cybernetic.nomadcybernetic.nomad
1,692212
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)
(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))
answered Jan 10 at 22:32
cybernetic.nomadcybernetic.nomad
1,692212
answered Jan 10 at 22:32
cybernetic.nomadcybernetic.nomad
1,692212
answered Jan 10 at 22:32
cybernetic.nomadcybernetic.nomad
1,692212
answered Jan 10 at 22:32
cybernetic.nomadcybernetic.nomad
1,692212
1,692212
Thank you so much! This will make the day fun for everyone (including the scorekeepers)
– shawnO
Jan 10 at 22:39
add a comment |
Thank you so much! This will make the day fun for everyone (including the scorekeepers)
– shawnO
Jan 10 at 22:39
Thank you so much! This will make the day fun for everyone (including the scorekeepers)
– shawnO
Jan 10 at 22:39
Thank you so much! This will make the day fun for everyone (including the scorekeepers)
– shawnO
Jan 10 at 22:39
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1392949%2fexcel-spreadsheet-is-there-a-way-to-have-a-easily-inputted-value-such-as-the-le%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
The answer to your question ("Is there a formula or way to do this?") is "yes". It's likely a
SUMIFcould 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