Lookup Multiple Results

I am trying to use the lookup functions to return a sum of all the results.
For example, i have a table such as this:

Jon 6
Aaron 8
Mark 7
Jon 8
Jon 6
Mark 8

I wish to lookup the text "Jon" and return a value of 22 (a sum of all the values corresponding to that text. I have tried using the vlookup function, but it only returns the first found value of 6. Is there a way i can return the sum of all the values relating to one name?

Originally Posted by Joffa21

I am trying to use the lookup functions to return a sum of all the results.
For example, i have a table such as this:

Jon 6
Aaron 8
Mark 7
Jon 8
Jon 6
Mark 8

I wish to lookup the text "Jon" and return a value of 22 (a sum of all the values corresponding to that text. I have tried using the vlookup function, but it only returns the first found value of 6. Is there a way i can return the sum of all the values relating to one name?

if names are in col A and numbers in col B
try this

=SUMIF(A1:A100,"=Jon",B1:B100)

Regards