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.

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


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

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.
--
Graduating 12/08 Econ/Fin looking for a corp Fin position most any metro.

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

On Thu, 22 May 2008 14:17:00 -0700, FinanceRyan
wrote:

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.