You can use the SUMIF() function to do this. Try out the following formula in
cell C1 of Sheet 2, and copy it down to C2:

=SUMIF('Sheet 1'!A:A,A1,'Sheet 1'!B:B)+SUMIF('Sheet 2'!A:A,A1,'Sheet 2'!B:B)

HTH,

TK

"tiq" wrote:

Sheet 1
A B C D
1234 50
18901 60


Sheet 2
A B C D
1234 8-26-06 5
18901 7-26-06 2.5
18901 8-25-06 2.5
1234 9-2-06 10
6575 9-2-06 15



in column C sheet 1 Row 1 I need it to add the two entries for #1234.
Sheet 2 will be added to constantly. At this point there are only 2 entries
for #1234 but that will change about 3 times a week. The function needs to
find the numbers on Sheet 2 based on the numbers on Sheet 1.

Sheet 1 should look like the following based on the above

A B C
D
1234 50 15
18901 60 5