You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Numbers always INDIRECT same cell from previous sheet

How to reference to always indirect the same cell for the previos sheet?

example sheet 1, sheet 2, sheet3...

sheet 2 c3=sheet 1 a1 + sheet 2 a2

sheet 3 c3=sheet 2 a1 + sheet 3 a2

sheet 4 c3=sheet 3 a1 + sheet 4 a2

and so on as a formula could copy to the next sheet # c3 maintaining the same, thanks

Posted on Nov 16, 2024 1:30 PM

Reply

There are no replies.

Numbers always INDIRECT same cell from previous sheet

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.