Greetings. I am trying to add multiple values in one column based on
multiple values of the same value (text) in another column. A little
simpler said . . . in column B I have a list of usernames. In column D
I have number values (a number showing how many times that person made
an entry for example). I need a formula that will look down through
column B and everytime it sees a particular username, it adds up all
of the numbers in column D on the same row that username showed up.
Hopefully the example below with make it more plain.


Column B Column D
usrjsmith 3
usrbjohnson 5
usrlgold 2
usrjsmith 7
usrjsmith 2
usrbjohnson 4
usrjsmith 8

So, looking at the example above . . .I need a formula that will look
down through column B and say 'usrjsmith=20', 'usrbjohnson=9',
'usrlgold=2'. I meesed with Vlookup but couldn't get that to do what I
needed. Any ideas?