That did the trick. Thank you very much.

"Mike H" wrote:

Maybe

=SUM(INDIRECT("B1:M1"))

Mike

"Doug" wrote:

The formula still changes when I do that.

"JLatham" wrote:

Yes, simply change the formula in column A to
=SUM($B1:$M1)
that'll keep the column references from changing even when you insert the
new column B.

"Doug" wrote:

I would like to create a formula in Col A that would go out 12 columns (B -
M) and then be able to insert a new column B and have the formula remain
=Sum(B1:M1) and not change to =Sum(C1:N1). Is that possible?