SUM formula automatically updating

  • Thread starter Thread starter Rlolar
  • Start date Start date
R

Rlolar

Hello!

I have a spreadsheet that has January in column D thru December i
column O. My formula in column P is only for year to date numbers, s
I have the formula

=SUM(D1:L1)

so I only sum Jan - Sept. HOWEVER, when I put in a number in column
(October), Excel is AUTOMATICALLY updating my formula to

=SUM(D1:M1).

How do I prevent this from happening (outside of using $ - I know ho
to do that, but there must be some option my spreadsheet has that i
creating this automatic update - I have NEVER seen this before toda
:)

Thanks in advance!

Rlola
 
Try:

<Tools> <Options> <Edit> tab,
And *uncheck*
"Extend List Formats & Formulas".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hello!

I have a spreadsheet that has January in column D thru December in
column O. My formula in column P is only for year to date numbers, so
I have the formula

=SUM(D1:L1)

so I only sum Jan - Sept. HOWEVER, when I put in a number in column M
(October), Excel is AUTOMATICALLY updating my formula to

=SUM(D1:M1).

How do I prevent this from happening (outside of using $ - I know how
to do that, but there must be some option my spreadsheet has that is
creating this automatic update - I have NEVER seen this before today
:)

Thanks in advance!

Rlolar
 
Back
Top