Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sum: sum only profit/loss (office xp)

    hello, i need to choose to sum figures that are >0 and <0 over a range more than thousand of cells. can someone help me here? attached is a sample task.

    thanks a lot.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sum: sum only profit/loss (office xp)

    In your example workbook:

    <pre>=SUMIF(A2:A16,">0")

    =SUMIF(A2:A16,"<0")
    </pre>

    Legare Coleman

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: sum: sum only profit/loss (office xp)

    =SUMIF(A2:A1000,">0")

    =SUMIF(A2:A1000,"<0")

    Change ranges as appropriate

    Steve

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

    Re: sum: sum only profit/loss (office xp)

    Hi,

    Set B2 to =SUMIF(A2:A16,">0",A2:A16)
    Set C2 to =SUMIF(A2:A16,"<0",A2:A16)

    For your example.

    Adjust the A2:A16 refernces as appropriate for your real list size.

  5. #5
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sum: sum only profit/loss (office xp)

    Coleman and Steve and Kieran,
    Thanks. Thanks a lot.

Posting Permissions

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