Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sum column with both - & + numbers

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have two columns with both negative and positive numbers, how can I sum both the negative and positive numbers separatly? The columns are D18:D34 and H13:H34. Thanks in advance for any help. AL

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I assume you'd want the negative numbers summed and displayed in one cell, and the positive (or essentially 0 and above) numbers summed and displayed in a separate cell.

    So, try this in one cell:
    Positive (0 and above:
    =SUMIF(D18:D34,">=0")

    and for summing negative numbers in another cell:
    =SUMIF(D18:D34,"<0")

    Is that what you want?
    If so, repeat for your other range and you are good to go.


  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    for negative numbers try =SUMIF(D18:D34,"<0",D18:D34)+SUMIF(H13:H34,"<0",H13:H34) and for positive numbers =SUMIF(D18:D34,">0",D18:D34)+SUMIF(H13:H34,">0",H13:H34)
    by the way, i notice that the range for column d is different to column h (ie. d is row 18 to 34, while h is row 13 to 34). if this is a typo you'll have to amend the ranges in these formulas

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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