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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top