View Single Post
 
Old 04-19-2009, 02:24 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Quote:
Originally Posted by Bird_FAT View Post
So please - if you wish help on this forum can you rephrase your question and tell us:

  • What is the situation that you are in
  • What data do you have for us to work with
  • What is it exactly that you want to be able to do
  • What have you already tried

With this information, we may be able to help you - otherwise we will all just have to look on in despair!
Having said that - I'll make a guess (but no promises!):

The file you uploaded requires a formula in SHEET Expenses, CELL B6 that will show the total in SHEET Expenses in Company, CELL B11!

If that is all you are looking for then the answer is:
Code:
='Expenses in Company'!B11
To make this, you would click on SHEET Expenses, CELL B6 and do the following:

  • Make sure the cell is the active one
  • Type '=' (without the apostrophes)
  • Click on the 'Expenses in Company' tab
  • Click on CELL B11
  • Press enter
If I have failed to answer your question correctly, then refer to the quote at the top of the post and rephrase your question using the four lines in the list!!
Reply With Quote