ADD cells from previos sheets ?
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 ?
|