Sum cells based on the value of other cell
up vote
1
down vote
favorite
I am facing a problem that seems trivial in Excel. What I need to do is simply this:
In short, I have a large file of prices linked to a few people and I need to know how much each person paid. I've tried things with VLOOKUP with not much success.
How can I accomplish this?
microsoft-excel worksheet-function cells
edited Nov 21 at 12:30
Anaksunaman
5,11321222
asked Nov 21 at 11:19
Adrien_p
61
add a comment |
up vote
1
down vote
favorite
I am facing a problem that seems trivial in Excel. What I need to do is simply this:
In short, I have a large file of prices linked to a few people and I need to know how much each person paid. I've tried things with VLOOKUP with not much success.
How can I accomplish this?
microsoft-excel worksheet-function cells
edited Nov 21 at 12:30
Anaksunaman
5,11321222
asked Nov 21 at 11:19
Adrien_p
61
Welcome to Super User! Could you please edit your question to include the things you've tried withvlookup? It would help the others to answer your question.
– Aulis Ronkainen
Nov 21 at 11:33
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I am facing a problem that seems trivial in Excel. What I need to do is simply this:
In short, I have a large file of prices linked to a few people and I need to know how much each person paid. I've tried things with VLOOKUP with not much success.
How can I accomplish this?
microsoft-excel worksheet-function cells
edited Nov 21 at 12:30
Anaksunaman
5,11321222
asked Nov 21 at 11:19
Adrien_p
61
I am facing a problem that seems trivial in Excel. What I need to do is simply this:
In short, I have a large file of prices linked to a few people and I need to know how much each person paid. I've tried things with VLOOKUP with not much success.
How can I accomplish this?
microsoft-excel worksheet-function cells
microsoft-excel worksheet-function cells
edited Nov 21 at 12:30
Anaksunaman
5,11321222
asked Nov 21 at 11:19
Adrien_p
61
edited Nov 21 at 12:30
Anaksunaman
5,11321222
asked Nov 21 at 11:19
Adrien_p
61
edited Nov 21 at 12:30
Anaksunaman
5,11321222
edited Nov 21 at 12:30
Anaksunaman
5,11321222
edited Nov 21 at 12:30
Anaksunaman
5,11321222
5,11321222
asked Nov 21 at 11:19
Adrien_p
61
asked Nov 21 at 11:19
Adrien_p
61
asked Nov 21 at 11:19
Adrien_p
61
61
Welcome to Super User! Could you please edit your question to include the things you've tried withvlookup? It would help the others to answer your question.
– Aulis Ronkainen
Nov 21 at 11:33
add a comment |
Welcome to Super User! Could you please edit your question to include the things you've tried withvlookup? It would help the others to answer your question.
– Aulis Ronkainen
Nov 21 at 11:33
Welcome to Super User! Could you please edit your question to include the things you've tried with
vlookup? It would help the others to answer your question.– Aulis Ronkainen
Nov 21 at 11:33
Welcome to Super User! Could you please edit your question to include the things you've tried with
vlookup? It would help the others to answer your question.– Aulis Ronkainen
Nov 21 at 11:33
add a comment |
2 Answers
2
active
oldest
votes
up vote
2
down vote
You need SUMIF() formula.
In your specific case =SUMIF(B$2:B$9;D4;A$2:A$9) will give you the sum for Name1 then paste it down for Name2 and Name3
answered Nov 21 at 11:30
Kevin Anthony Oppegaard Rose
571311
add a comment |
up vote
1
down vote
SUMPRODUCT function can help you get the result:
=SUMPRODUCT(($B$2:$B$9=E4)*($A$2:$A$9))
answered Nov 22 at 8:53
Lee
79917
Nice one @Lee,, you get perfect 10 ☺
– Rajesh S
Nov 22 at 11:33
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
You need SUMIF() formula.
In your specific case =SUMIF(B$2:B$9;D4;A$2:A$9) will give you the sum for Name1 then paste it down for Name2 and Name3
answered Nov 21 at 11:30
Kevin Anthony Oppegaard Rose
571311
add a comment |
up vote
2
down vote
You need SUMIF() formula.
In your specific case =SUMIF(B$2:B$9;D4;A$2:A$9) will give you the sum for Name1 then paste it down for Name2 and Name3
answered Nov 21 at 11:30
Kevin Anthony Oppegaard Rose
571311
add a comment |
up vote
2
down vote
up vote
2
down vote
You need SUMIF() formula.
In your specific case =SUMIF(B$2:B$9;D4;A$2:A$9) will give you the sum for Name1 then paste it down for Name2 and Name3
answered Nov 21 at 11:30
Kevin Anthony Oppegaard Rose
571311
You need SUMIF() formula.
In your specific case =SUMIF(B$2:B$9;D4;A$2:A$9) will give you the sum for Name1 then paste it down for Name2 and Name3
answered Nov 21 at 11:30
Kevin Anthony Oppegaard Rose
571311
answered Nov 21 at 11:30
Kevin Anthony Oppegaard Rose
571311
answered Nov 21 at 11:30
Kevin Anthony Oppegaard Rose
571311
answered Nov 21 at 11:30
Kevin Anthony Oppegaard Rose
571311
571311
add a comment |
add a comment |
up vote
1
down vote
SUMPRODUCT function can help you get the result:
=SUMPRODUCT(($B$2:$B$9=E4)*($A$2:$A$9))
answered Nov 22 at 8:53
Lee
79917
Nice one @Lee,, you get perfect 10 ☺
– Rajesh S
Nov 22 at 11:33
add a comment |
up vote
1
down vote
SUMPRODUCT function can help you get the result:
=SUMPRODUCT(($B$2:$B$9=E4)*($A$2:$A$9))
answered Nov 22 at 8:53
Lee
79917
Nice one @Lee,, you get perfect 10 ☺
– Rajesh S
Nov 22 at 11:33
add a comment |
up vote
1
down vote
up vote
1
down vote
SUMPRODUCT function can help you get the result:
=SUMPRODUCT(($B$2:$B$9=E4)*($A$2:$A$9))
answered Nov 22 at 8:53
Lee
79917
SUMPRODUCT function can help you get the result:
=SUMPRODUCT(($B$2:$B$9=E4)*($A$2:$A$9))
answered Nov 22 at 8:53
Lee
79917
answered Nov 22 at 8:53
Lee
79917
answered Nov 22 at 8:53
Lee
79917
answered Nov 22 at 8:53
Lee
79917
79917
Nice one @Lee,, you get perfect 10 ☺
– Rajesh S
Nov 22 at 11:33
add a comment |
Nice one @Lee,, you get perfect 10 ☺
– Rajesh S
Nov 22 at 11:33
Nice one @Lee,, you get perfect 10 ☺
– Rajesh S
Nov 22 at 11:33
Nice one @Lee,, you get perfect 10 ☺
– Rajesh S
Nov 22 at 11:33
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1377251%2fsum-cells-based-on-the-value-of-other-cell%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
Welcome to Super User! Could you please edit your question to include the things you've tried with
vlookup? It would help the others to answer your question.– Aulis Ronkainen
Nov 21 at 11:33