Recursive VLookup

Microsoft Office excel 2007 home & stude...
July 26, 2010 at 01:42:46
Specs: Windows XP

I am having a problem summing up the values of a Vlookup results. In my particular case I have a monthly sheet that has codes of items purchased in that month along with the corresponding item and the cost in a transaction.

Now in my monthly sheet I have to display the total amount of sale for an item. I am trying to use Vlookup for the item but since their are multiple entries in the monthly sheet for that item the Vlookup is returning the first item it finds in the list. where as my goal is to find the sum of the amounts for that code of item. Is Vlookup the right tool or should I use something else...or is their a combination that I need to use in this case...

thanks for your help. lemme know if I have not made the problem clear...and I will try again...


See More: Recursive VLookup

Report •

July 26, 2010 at 04:46:23

look at the SUMIF() function.

It will SUM values in one column when corresponding rows in another column contain the item name or number.

It looks something like this:
Product codes in column A
Transaction amounts in column B
=SUMIF(A1:A100,"CodeNumber", B1:B100)


Report •

July 26, 2010 at 13:45:34
Thanks Humar, I got the worked with the SUMIF function...


Report •

Related Solutions

Ask Question