I have one workbook (the master file) that I update biweekly with information I get from a report. In workbook 1, I have an ID number, description, and the current total. In workbook 2, I have the ID number, description (may vary from workbook 1) and the total for the period downloaded (anything that has occurred since the last download date).

When I say "current total" for workbook 1, it looks like this:
=5+95+108+52+34

or something to that nature. How can I add the new number from each new workbook 2 to the existing running total in workbook 1?

So if the new number for the above ID in workbook 2 is 68, it would look like
=5+95+108+52+34+68

Any help would be greatly appreciated!