Excel workbooks

[JohnD]

I am creating a profit and loss acounts in excel with several worksheets : ie
one for wages, one for motoring expenses and one for telephony expenses etc.
On some of the worksheets I have totals from 3 different items such as land
line telephone and mobile telephone ect each with a separate total. Is there
a way to create a link so that all three colums can be added together and the
total sum added and placed in the cell on the P & L worksheet.

 

[tim]

http://www.keithjbrown.co.uk/vworks/excel/excel2.php

 

[FinanceRyan]

I think the simplest thing to do is to click in the cell you want the total.
The put a = and then go to the telephone sheet and click on the land line
number, which should show up in the fx box as

=telephonesheet!landcell

then you add a + after that

=telephonesheet!landcell +

then you click on the mobile phone cell giving you

=telephonesheet!landcell + telephonesheet!mobilecell

then adding an another + and clicking on the cell again for each additional
cell needed.

Ryan

PS I dont know if it is rude to respond to a responded to post.. if it is
I'm sorry I know there is serious board etiquette.

 

[Gord Dibben]

Not rude to respond to a responded to post.

You could leave some of the original post attached so's we know which question
got replied to.


Gord Dibben MS Excel MVP