Excel Memory?

[Stattfinder]

I hope the title is not misleading
here's what I am trying to do:
if I have some namers, lets say Peter, George, Steven, and each has a number (lets say which represents number of some items)
It's something like this

A B
1. Peter 2
2. George 3
3. Steven 5

So, suppose I import a new list with similar entries, that may exclude some names while include others, suppose I import such a list (let's say from a TXT file)
Matt, 10
Peter, 3
George, 6
So Steven is no longer needed, Matt is a new entry, and Peter and George continue to be active entries, and I'll just add the numbers, so I will get

A B
1. Matt 10
2. Peter 5 (which is 2+3)
3. George 9 (which is 3+6)

So, is there a possibility to make such a thing: as you can see the sequence of entries is changed, some entries are the same and I just add the numbers (in the B column), some entries are not there, there are some new entries. Can Excel achieve this, and if not - if you are so kind would you suggest something similar
thanks in advance

[shg]

Maybe like this:

Please Login or Register  to view this content.

Data entry is in columns A/B, D/E, G/H, ...

The formula in F2 and copied down, and copied over to col I, L, etc., is

=E2 + SUMIF(A:A, D2, B:B )

[Stattfinder]

thank you a lot !