Find all matches in column A and sum their corresponding values in Column B

[Grizraz]

As the subject states, I have a list of names in column A and numeric values in column B.
Don....10
Jim.....12
Jim.....10
Joe.....07
Jon.....07
Jon.....-10

I would like to find all matches for the name "Jon" in column A and sum the numeric values in Column B as follows:
Jon.....-3

I'm sure this relates to MATCH or INDEX or VLOOKUP but I am stumped wrapping my head around it.

[Rick Rothstein]

Try this formula...

=SUMIF(A:A,"Jon",B:B)

If you want to make the formula more efficient, use defined ranges...

=SUMIF(A1:A6,"Jon",B1:B6)

[Grizraz]

Thank you Rick Rothsein