Adding values from a different worksheet

S

sue

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.
 
T

Tevuna

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

T. Valko

Try something like this:

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