Adding values from a different worksheet

[Guest]

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.

 

[Guest]

Something like:
=[H V]LOOKUP("Location","Sheet2!Range","Totals",0)
See HELP for more on these functions

 

[T. Valko]

Try something like this:

=SUMIF(Sheet1!_location_number_range,location_number,Sheet1!_expenditures_range)