+ Reply to Thread
Results 1 to 6 of 6

Sum adds rather than subtracts negative numbers?

  1. #1
    Registered User
    Join Date
    10-20-2012
    Location
    calif
    MS-Off Ver
    Excel 2007
    Posts
    19

    Sum adds rather than subtracts negative numbers?

    I'm new at this so I'm sure it is operator error and there is a simple solution, BUT . . .

    I have several sheets that have columns (of currency figures) that are summed at the bottom of the column.

    The sums from like columns on each sheet are then summed together and appear in their own cell on a different sheet.

    The front sheet takes the sum from each category from each sheet and puts the total amount in it's own cell. For instance, one category is a net gain (or loss) for a particular stock over multiple purchases. Another is net sale price for one options over several sales.

    Those cells on the front sheet are then summed together in different ways, i.e. net from stock sales plus net from options sales.

    The problem I am running into is that when the numbers are summed together, if one of the numbers in a cell is a negative number (like a net loss from stock sales) it is added into the total rather than subtracted.

    I'm not sure if I've explained this in a clear enough way or not, but hoping someone can help me figure out how to make this work :o)
    Last edited by innatedoc; 10-23-2012 at 01:32 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Sum adds rather than subtracts negative numbers?

    When you are in Advanced reply, click on the paperclip to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    10-20-2012
    Location
    calif
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sum adds rather than subtracts negative numbers?

    Did you mean you want me to upload a screenshot? If so, here it is. The sum of C1 - 6 should be 945.94, but it is adding in the 1193 instead of recognizing that it is a negative number and subtracting it.
    Attached Images Attached Images

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Sum adds rather than subtracts negative numbers?

    uploading a picture of your problem might just get you a picture of your solution...a workbook is a far better option to upload
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    10-20-2012
    Location
    calif
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sum adds rather than subtracts negative numbers?

    Sorry - I'm pretty unexperienced at this. I think this is what you're asking for?
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-20-2012
    Location
    calif
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sum adds rather than subtracts negative numbers?

    I figured out wher I had the formula wrong. Thanks for taking a look :o)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1