We help IT Professionals succeed at work.

How do i do a Sum Vlookup

tols12
tols12 asked
on
I have a spreadsheet with data using ODBC. On my spreadsheet, i have an identifier for each piece of data. I am trying to find a way i can sum the data that has the same identifier. I have attached a screenshot of what i am trying to do. See pic attached.

You will see on the picture, i have one worksheet with the data. On the 2nd worksheet, i want to do a sum vlookup to sum all of the "Prices" that are associated with the ID number 32. I don't know if sum vlookup exists, but this is just to give you an idea what i am trying to do. Thanks!!! Sum Vlookup Example
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2013
Commented:
Try SUMIF

In G5

=SUMIF(A$5:A$8,F5,C$5:C$8)

and copy down to G7

regards, barry
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

if you don't want to manually type the ID numbers in Sheet 2, you can also use a Pivot Table to sum up your results.

Drag the ID to the row area and drag the Price to the Values area. See attached.

cheers, teylyn
Book2.xlsx

Author

Commented:
Both answers were very helpful!!! For what I need the sumif works great. But i will be able to use the pivot table. Thank you!!!

Commented:
Similar long hand version
SUMIF(A:A,F7,C:C)

Author

Commented:
Thanks for the post borgunit. Yes, that is actually what i did. Instead of a single cell, I used the whole column as you suggested. Thank you!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.