Hi, 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...

rgds

Hi, 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)Regards

Thanks Humar, I got the result...it worked with the SUMIF function... Rgds,

Abhi

Ask Your Question

Weekly Poll

Do you think Samsung's Bixby will compete well against other phone AI systems?

Discuss in The Lounge

Poll History