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!

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!

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!