-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Need formula to look up a specific text in Column A and sum up all matched text from Column B
- Thread starter jandtng
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,795
- Office Version
- 365
- Platform
- Windows
This can be done with a simple SUMIF formula.
See here for more details and examples: SUMIF Function
Excel Formula:
=SUMIF(A1:A7,E2,B1:B7)See here for more details and examples: SUMIF Function
Upvote
1
Solution
That's what I'm looking for. Thank you so much, I have so much to learn from this chatroom.
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,795
- Office Version
- 365
- Platform
- Windows
You are welcome.
Glad I was able to help!
Note that there is a similar COUNTIF function, which counts the matching records, instead of summing them.
And there are also similar SUMIFS and COUNTIFS functions, which do the same thing, but allow for multiple criteria (instead of just one single one).
Lots of great Excel functions!
Glad I was able to help!
Note that there is a similar COUNTIF function, which counts the matching records, instead of summing them.
And there are also similar SUMIFS and COUNTIFS functions, which do the same thing, but allow for multiple criteria (instead of just one single one).
Lots of great Excel functions!
Upvote
0
