Vlookup with more than 1 match
I have a range with two columns in which i would like to reference the item in the first column and report back the corresponding value in the second column. Perfect for vlookup. Only problem is there are several rows in column one that will match my lookup value. I need a formula that will sum the total values in the second column that match the reference in the first column. See attached spreadsheet.
Try:
=SUMIF($D$6:$D$12,A6,$E$6:$E$12)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Perfect, so how do i marked this post "SOLVED"?
Click on Edit in your first post, click Go Advanced, pick Solved from prefix menu.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks