Using Vlookup to bring over a subtotal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a spreadsheet that contains a list of part numbers and their quantity
on hand at different locations. When I use Vlookup for the quantity on hand,
it returns only the first location in the list. It doesn't bring the total
for all locations. I would like to lookup each part number's total quantity
on hand. A total of all the locations for each part number. Can Vlookup do
this or do I have to use another function?


Thank You,

Richard
 
=sumif([Book2.xls]Sheet1!A:A,F12,[Book2.xls]Sheet1!C:C)

where F12 holds the part number to sum . Column C in your data table
contains the quantity and column A, the part numbers.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add/Subtract columns from tab to tab in same file 3
subtotaling a column based on three others 3
Copying cell contents a specified number of times 4 mail merge? 2
description of count in subtotal 1
Urgent Help needed!!!! 3
Values in a array are disappearing 2
Calculating subtotals 22
Using Vlookup, hyperlinks do not work 1

Back
Top