Vlookup to return the sum of multiple matches
- I have a summary page with a list of products and need to show production volume of each product, product code in column A and total of production to be in column B. - I have a report detailing products manufactured by sites, with site in column A, product code in column B and volume in Column C. The difficulty is that the production site information is "stacked", so I have repeating product codes in the same column (each site follows the other down the page and each site manufactures the same products). How do I use a Vlookup (or what should I use) to find every instance of a match in a list and return the summed value of the query (in this example match column A on the summary sheet with column B on the production report and sum every volume value against that product type from column C)? I hope this is clear enough :rolleyes: -- AussieExcelUser ------------------------------------------------------------------------ AussieExcelUser's Profile: http://www.excelforum.com/member.php...o&userid=32326 View this thread: http://www.excelforum.com/showthread...hreadid=566517 |
Vlookup to return the sum of multiple matches
Assuming your "report detailing products" is named: Sheet2
In your summary sheet, Try in B2: =SUMIF(Sheet2!B:B,A2,Sheet2!C:C) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "AussieExcelUser" wrote: - I have a summary page with a list of products and need to show production volume of each product, product code in column A and total of production to be in column B. - I have a report detailing products manufactured by sites, with site in column A, product code in column B and volume in Column C. The difficulty is that the production site information is "stacked", so I have repeating product codes in the same column (each site follows the other down the page and each site manufactures the same products). How do I use a Vlookup (or what should I use) to find every instance of a match in a list and return the summed value of the query (in this example match column A on the summary sheet with column B on the production report and sum every volume value against that product type from column C)? |
Vlookup to return the sum of multiple matches
Thanks Max, that worked a treat. -- AussieExcelUser ------------------------------------------------------------------------ AussieExcelUser's Profile: http://www.excelforum.com/member.php...o&userid=32326 View this thread: http://www.excelforum.com/showthread...hreadid=566517 |
Vlookup to return the sum of multiple matches
"AussieExcelUser" wrote:
Thanks Max, that worked a treat. Nice to hear that! Thanks for callback. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 12:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com