[Solved] Excel is correcting a formula that isn't brok

  • A1: Calls In
    B1: Calls Out
    C1: Faxes
    D1: Hours Worked
    E1: Total Contacts


    E2: =SUM(A2:C2)


    When I enter a value in A2, sum shows that value.
    When I enter a value in B2, sum adds it in.
    When I enter a value in C2, sum adds it to the total.


    When I enter a value in D2, the SUM formula changes to =SUM(A2:D2).


    Arrrrrrrrgh!!!!! Why is this happening!!!!!

  • Go to Tools > Options > Edit


    On the right side, you will find:


    "Extend List formats and formulas"


    Uncheck that box.


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

  • Shouldn't affect anything else. It is designed as "MS Time-Saver" assuming they know how you want to work. Many times it is useful, but as you discovered, this will interfere with some kinds of projects.


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!