Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto_mania (2003 & 2007)

    A1:A5 enter '1's'
    Formula in A11 =sum(A1:A5)
    then add numbers A6;A10
    Formula in A11 changes.
    Why?
    Have a play with various options...
    Thanks
    RA

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Auto_mania (2003 & 2007)

    Excel is trying to be intelligent and altering the formula to what it thinks you want. If you want the formula to be fixed use absolute references, viz =SUM($A$1:$A$5)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •