Adding values from a different worksheet
 

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.

Adding values from a different worksheet
 

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

"sue" wrote:

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.

Adding values from a different worksheet
 

Try something like this:

=SUMIF(Sheet1!_location_number_range,location_numb er,Sheet1!_expenditures_range)

--
Biff
Microsoft Excel MVP


"sue" wrote in message
...
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.