Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Spring Arbor, Michigan, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Absolute Sum (Excel97)

    I would like to calculate the absolute sum of a column or row of numbers. Is there a straight forward method of accomplishing this?

    Thanks

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Absolute Sum (Excel97)

    Try the normal form for sum eg =sum(a1:a7) then edit the formula to =sum(abs(a1:a7)) and then press ctrl-shift-enter as you complete the fomula.
    This will give the absolute sum of the range.

    This will then show the formula as { =sum(abs(a1:a7)) } which indicates that it is an array formula.

Posting Permissions

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