ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vlookup to return the sum of multiple matches (https://www.excelbanter.com/excel-discussion-misc-queries/102198-vlookup-return-sum-multiple-matches.html)

AussieExcelUser

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


Max

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)?


AussieExcelUser

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


Max

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