Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching data on seperate worksheets
I want to accomplish the following but am having a problem getting it
to work. Two worksheets. Sheet1 colA has a value of 123 and colb has no value yet. Sheet2 colA row1, 2, and 3 have a value of 123 colB row1, 2 and 3 have a value of say 100. I want to from Sheet1 ColB row1 sea sheet2 col A for all matches to sheet1!A1 if any row in colA of sheet2 matches Sheet1!A1 it adds the contents of Sheet2 col B whatever rows have been matched, in this case row1, 2 and 3 and places the total in Sheet1!B1 HELP! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching data on seperate worksheets
Say Sheet 2 Range A1:B6 has:
123 100 123 50 123 25 234 50 234 35 234 10 Sheet1 Range A1:B2 has: 123 =SUMIF(Sheet2!$A$1:$A$6,Sheet1!A1,Sheet2!$B$1:$B$6 ) 234 =SUMIF(Sheet2!$A$1:$A$6,Sheet1!A2,Sheet2!$B$1:$B$6 ) B1 will display 175 B2 will display 95 Is this close? "Dale" wrote in message om... I want to accomplish the following but am having a problem getting it to work. Two worksheets. Sheet1 colA has a value of 123 and colb has no value yet. Sheet2 colA row1, 2, and 3 have a value of 123 colB row1, 2 and 3 have a value of say 100. I want to from Sheet1 ColB row1 sea sheet2 col A for all matches to sheet1!A1 if any row in colA of sheet2 matches Sheet1!A1 it adds the contents of Sheet2 col B whatever rows have been matched, in this case row1, 2 and 3 and places the total in Sheet1!B1 HELP! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching data on seperate worksheets
does exactly what I want it to do..thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching & combining data from seperate worksheets | Excel Worksheet Functions | |||
Matching address with two seperate worksheets | Excel Worksheet Functions | |||
Matching data/columns from two seperate files | Excel Discussion (Misc queries) | |||
How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
Vlook up for matching data in two seperate sheets | Excel Discussion (Misc queries) |