SUM from another worksheet

  • Thread starter Thread starter liftapia
  • Start date Start date
L

liftapia

Worksheet A has a Budgeted Value of $100 and next to it I want a valu
entered that tells me what I have left from what I have spent

The values of what I have spent are on Worksheet B

How do I make it to where one Worksheet talks to another? Basically

I want to take the total amount from what I spent in Worksheet B an
deduct it from by Budget in Worksheet
 
liftapia,

Assuming that your total on Sheet A is in Cell C9, then put this in D9:

=C9-Sheet2!E20

where Sheet2 is the name of your Sheet B and E20 is the sum of what you have
already spent on that sheet. Make sure you keep the ! in there. Hope this
helps!

Mark
 

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

Similar Threads

linking cells between worksheets 1
linking worksheets in Excel 2007 5
function 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Comparing the difference between 2 worksheets 2
Detailed worksheet value entered automatically in Summary workshee 2
Amount Spent vs Budget 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top