HI I have a spreadsheet document where I register tournament results with a sheet for each tournament date. I want to have a cumulative column where to show cumulative information. I have already achieved this manually.

For Example, on sheet 1, I have the following data:

Team     Points   Accum Points
TeamA    4        4
TeamB    2        2
TeamC    1        1


On sheet 2, I have this:

Team     Points   Accum Points
TeamA    2        6
TeamB    1        3
TeamC    4        5


The formula for column "Accum Points" on row 2 of sheet 2 is: Sheet1!C2 + B2

The formula for column "Accum Points" on row 2 of sheet 3 is: Sheet2!C2 + B2

The formula for column "Accum Points" on row 2 of sheet 4 is: Sheet3!C2 + B2

and so on...Each time I add a date, I copy the previous sheet, modifying the columns formula.

I would like to have a "generic" formula for all sheets (except sheet 1) that would be something like

[[ActualSheet]-1]!C2 + B2 or [PreviousSheet]!C2 + B2

Anyone knows if this can be achieved?

Thanks,

Lisandro

-