SUMIF and VLOOKUP???

[needhelp13]

I cant get this to work...

If I have data like this:
Column A Column B
Mary 1
Mary 3
Mary 1
John 3
John 4

How can I have in column C the sum by name so Mary = 5 and John = 7?

I have => SUMIF(B1:B5,A1) but the result I get is 0, and when I do SUMIFS(B1:B5,vlookup(A1,A1:B5,2),B1:B5) I get error message?

Thanks for your help!

[Fotis1991]

Try

=SUMIF($a$1:$a$5,a1,$B$1:$B$5)

[Jonmo1]

The syntax for sumif is

=SUMIF(CriteriaRange,Criteria,RangeToSum)

Try
=SUMIF(A$1:A$5,A1,B$1:B$5)