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!
Bookmarks