I have a spreadsheet to serve as a transaction log for Monopoly... my friends the geeks play it occasionally at my house and we love the immediate charts that OOo Calc provides for our transactions. What I want to do is have a cell with the turn number, like 1, 15, 27, etc. Then in another cell, I want to create a formula that create a sum of everyone's net worth for that turn.
For example:
Cell E1 has the turn number.
Columns A, B, and C have each player's net worth, one column per player and one row per turn, so A1 has the first player's first turn's log, C2 has the third player's second turn's, etc.
E5 has the sum of all players' net worth at that point of the game. So, I want to do something like this:
=SUM(A[E1]; B[E1], C[E1])
which should dynamically resolve into:
=SUM(A7; B7; C7)
if E1 has a 7 in it.
Is that doable? I am sure that it's not an incredibly esoteric or unusual action in a spreadsheet...
For example:
Cell E1 has the turn number.
Columns A, B, and C have each player's net worth, one column per player and one row per turn, so A1 has the first player's first turn's log, C2 has the third player's second turn's, etc.
E5 has the sum of all players' net worth at that point of the game. So, I want to do something like this:
=SUM(A[E1]; B[E1], C[E1])
which should dynamically resolve into:
=SUM(A7; B7; C7)
if E1 has a 7 in it.
Is that doable? I am sure that it's not an incredibly esoteric or unusual action in a spreadsheet...
Facebook
Twitter