Jm

[machundajunior]

Hey guys, may i get your help-

I have two sheets, one with the summary of names of the other 2nd sheet which has couple of other data, now I want to use this summary to sum up the corresponding names value on the other column which are most of them are found with duplicates.

Am used to vlook up to vlook up such values but this time I fail to choose whether it is vlookup or sumif or the mix of two, here is an example:

SOURCE SHEET:
A B
frank 2
anna 3
anna 4
anna 5
frank 7

i want therefore, anna be summed up to 12, likewise for frank etc. i have thousands of these names and i need a formula that will solve this one...

pls help

JM

[NBVC]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST