Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Cambridge, England
    Posts
    47

    Unanswered: SUM range with condition

    Hi

    Wondering if anyone can help me with a formula, I have a column (G) with a list of values that can be positive, negative or 0. I have two other cells, I want one to show the total of all the cells in G which are positive and the other to show the sum of those which are negative. Is this possible to convey in a single formula

    Any ideas gratefully received

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Cambridge, England
    Posts
    47
    have answerd myself, thanks

    SUMIF of course...

  3. #3
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: SUM range with condition

    Originally posted by nstaward
    Hi

    Wondering if anyone can help me with a formula, I have a column (G) with a list of values that can be positive, negative or 0. I have two other cells, I want one to show the total of all the cells in G which are positive and the other to show the sum of those which are negative. Is this possible to convey in a single formula

    Any ideas gratefully received

    Thanks
    See my post response in this forum Subject: Grouping Category

Posting Permissions

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