I have a budget workbook that includes a breakdown of expenditures (checkbook
register style) in one worksheet (worksheet(1)). Each breakdown item
includes a location number. There are a total of 20 location numbers.

In another worksheet (worksheet (2)) I have a total amount spent field for
each location. I am trying to find a formula that will add all the amounts
from each location and display the total in worksheet(2).

Please advise.