Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 31st 06, 07:32 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1
Default 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


--
AussieExcelUser
------------------------------------------------------------------------
AussieExcelUser's Profile: http://www.excelforum.com/member.php...o&userid=32326
View this thread: http://www.excelforum.com/showthread...hreadid=566517


  #2   Report Post  
Old July 31st 06, 09:05 AM posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default 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)?

  #3   Report Post  
Old July 31st 06, 11:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1
Default 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

  #4   Report Post  
Old August 1st 06, 12:29 AM posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default 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
---


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup to Return a Range of Data James Excel Discussion (Misc queries) 0 July 13th 06 09:44 PM
VLookup Multiple Data Rows alexdwsn Excel Worksheet Functions 2 June 9th 06 11:24 AM
VLOOKUP to return multiple rows Miss Marple Excel Worksheet Functions 2 September 19th 05 11:08 AM
Multiple matches on VLOOKUP [email protected] Excel Worksheet Functions 2 May 9th 05 05:15 PM
Can vlookup return multiple matches in a single cell? cchristensen Excel Discussion (Misc queries) 3 December 2nd 04 01:56 AM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017