Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Sum of positive values only using 'IF'

    I have a column of numbers that can have negative and positive values but I need a formula that adds only the positive values from the column. Right now I have tried =SUM(IF('range'>0,'range' but the numbers are not adding up properly.
    ANy thoughts out there?

    Thanks,
    Dave

  2. #2
    Join Date
    Jan 2004
    Location
    Mexico
    Posts
    3

    Re: Sum of positive values only using 'IF'

    I wouldn't use 'IF', I would use 'SUMIF()' instead, this way you can set any criteria you want.

    Eg:

    =SUMIF(A1:A10,">0",A1:A10) don't forget quoting your criteria.

    This simple formula will add only the positive values from your range.

    I hope this can help.

    Bustamante

    Originally posted by yippdr
    I have a column of numbers that can have negative and positive values but I need a formula that adds only the positive values from the column. Right now I have tried =SUM(IF('range'>0,'range' but the numbers are not adding up properly.
    ANy thoughts out there?

    Thanks,
    Dave

  3. #3
    Join Date
    Jan 2004
    Posts
    2

    Re: Sum of positive values only using 'IF'

    You rule! Thanks so much!
    Dave
    Originally posted by Bustamante
    I wouldn't use 'IF', I would use 'SUMIF()' instead, this way you can set any criteria you want.

    Eg:

    =SUMIF(A1:A10,">0",A1:A10) don't forget quoting your criteria.

    This simple formula will add only the positive values from your range.

    I hope this can help.

    Bustamante

Posting Permissions

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