Combining absolute and relative reference for sum

[Guest]

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

 

[Myrna Larson]

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.