Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
agrandstaff@hotmail.com - 16 May 2007 17:46 GMT
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?
Mike H - 16 May 2007 18:02 GMT
Try this:-
=SUMIF(A1:A7,A1,B1:B7)

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

Mike

> 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
[quoted text clipped - 18 lines]
> 'usrlgold=2'. I meesed with Vlookup but couldn't get that to do what I
> needed. Any ideas?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.