I would like to find Total quantity for the products, which shares same stock number in a table. I like to use VLOOKUP if it is possible. Does anyone know how to do? Do I have to use another function for this?
I would like to find Total quantity for the products, which shares same stock number in a table. I like to use VLOOKUP if it is possible. Does anyone know how to do? Do I have to use another function for this?
Try SUMPRODUCT. It works in most of the multiple lookup cases.
I would like the same thing but would like to have a list of the matching data so Sumproduct won't do everything I need
g03go3go,
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
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.
Also, sumif will work. See the attached.
=Sumif(reference being tested,evaluation formula, Referece to range being summed based on first reference and evaluation formula)
Last edited by Whizbang; 10-30-2009 at 10:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks