Combining absolute and relative reference for sum
 

I have inserted a column in the middle of my spreadsheet that will contain a
total. I need to enter a formula in the column that will sum all the cells
in that row from column F to RC[-1]. My first value will always be in column
F, but the last value is relative since my sum will be in a different column
from month to month.

Thanks in advance for your help.

Denise

Combining absolute and relative reference for sum
 

Assuming the cell is N2, write the formula this way =SUM($F2:M2). The
formula will expand to include more columns if you insert those new columns at
columns G through M. OTOH, if you insert a new column N, pushing the formula
to the right, the sum will NOT include it. You also cannot insert a new column
F without redoing the formula, or using a different formula that uses, say,
the INDIRECT function.

On Wed, 3 Nov 2004 18:24:02 -0800, Denise
wrote:

I have inserted a column in the middle of my spreadsheet that will contain a
total. I need to enter a formula in the column that will sum all the cells
in that row from column F to RC[-1]. My first value will always be in column
F, but the last value is relative since my sum will be in a different column
from month to month.

Thanks in advance for your help.

Denise