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!