okey i have sheet 5 in this sheet there is a cell called J5

i want J5(in sheet5) = J5(in sheet5) + J5(in sheet4) + J5(in sheet3) + J5(in
sheet2).....etc

is that possible ?

Yes it is possible. Go to Sheet 5 and cell J5 and type:

=Sheet1!J5 + Sheet2!J5 + Sheet3!J5 + Sheet4!J5

In your question, you also showed having Sheet5!J5 in the formula. I don't
think
you meant for that to be there. I assume you want Sheet5!J5 to display the
total for J5 in Sheets 1 - 4.

Hope this helps,
Les

"Is it possible ?" wrote:

okey i have sheet 5 in this sheet there is a cell called J5

i want J5(in sheet5) = J5(in sheet5) + J5(in sheet4) + J5(in sheet3) + J5(in
sheet2).....etc

is that possible ?

A formula cannot refer to it own cell. So you cannot have what you want in
J5
But =SUM(Sheet1:Sheet5!J5) will work in another cell on the sheet
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Is it possible ?" wrote in message
...
okey i have sheet 5 in this sheet there is a cell called J5

i want J5(in sheet5) = J5(in sheet5) + J5(in sheet4) + J5(in sheet3) +
J5(in
sheet2).....etc

is that possible ?

Thanks alot for your reply but actually when i said from sheet 1 to sheet 4 i
meant it as an example is there any way to say

SheetN!J5+SheetN-1!J5+SheetN-2!J5+SheetN-3!J5....etc ???

"WLMPilot" wrote:

Yes it is possible. Go to Sheet 5 and cell J5 and type:

=Sheet1!J5 + Sheet2!J5 + Sheet3!J5 + Sheet4!J5

In your question, you also showed having Sheet5!J5 in the formula. I don't
think
you meant for that to be there. I assume you want Sheet5!J5 to display the
total for J5 in Sheets 1 - 4.

Hope this helps,
Les

"Is it possible ?" wrote:

okey i have sheet 5 in this sheet there is a cell called J5

i want J5(in sheet5) = J5(in sheet5) + J5(in sheet4) + J5(in sheet3) + J5(in
sheet2).....etc

is that possible ?