Simple Function

[Tasoli]

I'm trying to write what should be a simple function, but I don't have the knowledge to write it. I've discovered the =SUM command, but I'm not able to figure out how to combine enough commands to do what I'm trying to do. Here's what I'm trying to do:

Column A will have a name, column B will have a total of all columns from C to infinity. Here's the tricky part, I need Column B to have a sum equation that uses a row VARIABLE to determine what's being added, something like =SUM(C'%row''%row') or what have you, where '%row' is a real command. That's one of the parts I can't quite figure out. In addition, I need to write another variable that adds up the two cells above itself. So, if I place this variable in any cell, it will just add the numbers in the two cells above it together, but not need a specified row and column number to fetch the data from.

Make sense?

[Villeroy]

OFFSET(start_reference ; rows_offset ; cols_offset ; resize_rows ; resize_cols)
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_OFFSET_function

For instance:
OFFSET($A$1 ; 1 ; 2 ; 3 ; 4)
returns a reference to A1, 1 down, 2 to right, 3 rows tall, 4 columns wide => C2:F4

resize_rows and cols_offset can be negative as long as you stay within the bounds of the sheet.
resize_rows and resize_cols have to be positive.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org