SUM formula automatically updating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rlolar - 19 Oct 2004 19:20 GMT

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

Reply to this Message

RagDyer - 19 Oct 2004 19:39 GMT

Try:

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

Signature

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

Signature

Rlolar
------------------------------------------------------------------------
Rlolar's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=15471
View this thread: http://www.excelforum.com/showthread.php?threadid=270558

Reply to this Message