Function / Formula Help

[lellwood]

I need to create a formula / function (not sure what really) to recognize a name and every time that name comes up to add the dollar amount associated. For example:

Joe Smith ABC Account $100
Bob B DEF Account $200
Joe Smith GHI Account $300

How do I make a formula to recognize the lines with Joe Smith and to add the $ amount and total it?

[daddylonglegs]

Try SUMIF

If names are in column A and dollar amounts in B

=SUMIF(A:A,C1,B:B)

where C1 contains a name like "Joe Smith"

[lellwood]

How do I get the sum to recognize each instance of the particular name of Joe Smith?

[J-Dude]

=SUMIF(A2:A100, "=Joe Smith", B2:B100)

In the example, Excel will cycle through Column A, and if Joe Smith is in a cell, it will sum the number found in the corresponding Column B. Hope that helps make it a little clearer.

Though, I guess I'm just repeating the previous post