Need formula to look up a specific text in Column A and sum up all matched text from Column B

[jandtng]

Need formula to look up a specific text in E2 from Column A and sum up all matched text from Column B in F2. TIA

 

[Joe4]

This can be done with a simple SUMIF formula.

=SUMIF(A1:A7,E2,B1:B7)

See here for more details and examples: SUMIF Function

 

[jandtng]

This can be done with a simple SUMIF formula.

=SUMIF(A1:A7,E2,B1:B7)

See here for more details and examples: SUMIF Function

That's what I'm looking for. Thank you so much, I have so much to learn from this chatroom.

 

[Joe4]

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!