Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Sum up a number of matches in Vlookup in Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-02-2012
Member
 
Join Date: Feb 2012
Posts: 10
Sum up a number of matches in Vlookup in Excel

I need to run a vlookup for an exact value in a range and for each match calculate the total of the cell adjacent. For example, James appears in this list twice and I want to reach a sum of his sales listed. I know I can do a vlookup command, but I'm not sure what to do when there are multiple matches. Thanks.
Name Sales Name Total Sales
  • James $120 James
  • Bob $168 Bob
  • Randy $65 Randy
  • James $54 Henry
  • Henry $796 Pete
  • Pete $164 Alfred
  • Bob $638
  • Alfred $945
  • Randy $12
  • Henry $578
  • Alfred $324
  • Pete $179

Reply With Quote
  #2  
Old 24-02-2012
Member
 
Join Date: May 2011
Posts: 518
Re: Sum up a number of matches in Vlookup in Excel

Try the following : =SUMPRODUCT((A2:A13="James")*(B2:B13)) you may also get away with =SUMPRODUCT(($A$2:$A$13=A2)*($B$2:$B$13)) and drag down.
Reply With Quote
  #3  
Old 24-02-2012
Member
 
Join Date: May 2011
Posts: 410
Re: Sum up a number of matches in Vlookup in Excel

You can get by with SUMIF. In E1, copied down: =SUMIF(A:A,D1,B:B) where the unique names are listed in D1 down.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Sum up a number of matches in Vlookup in Excel"
Thread Thread Starter Forum Replies Last Post
Need help to get rid of #n/a error in Excel Vlookup Culpritism MS Office Support 2 24-02-2012 06:39 PM
Getting multiple matches result on Vlookup sum TheCarter MS Office Support 2 17-02-2012 01:08 PM
How to get yes or no in Vlookup in Excel Gurmeet MS Office Support 2 24-01-2012 03:57 PM
Multiple Matches Return To VLOOKUP Brunon Windows Software 5 26-11-2010 10:32 PM
Number stored as text in vlookup Alexander102 Windows Software 3 09-06-2009 09:00 AM


All times are GMT +5.5. The time now is 07:07 PM.