Adding multiple values in one column based on multiple values of the same value (text) in another column
 

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?

Adding multiple values in one column based on multiple values of t
 

Try this:-
=SUMIF(A1:A7,A1,B1:B7)

With your names in A1:A7 and numbers in B1:B7 and usrjsmith in A1

Mike




" wrote:

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?