Results 1 to 4 of 4

Thread: Return Positive Value of SUMIF
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2010
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Return Positive Value of SUMIF

    I am using the following sumif formula:

    =sumif(U5:U91,"2",N5:N91)

    N5:N91 contains all negative numbers, and I need to make them positive. How can I accomplish this?

    Thank you!

  2. #2
    Board Regular
    Join Date
    Jul 2007
    Location
    Sydney
    Posts
    4,392
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Return Positive Value of SUMIF

    Hi jmattingly85,

    Try this:

    =ABS(SUMIF(U5:U91,"2",N5:N91))

    Regards,

    Robert

  3. #3
    Board Regular
    Join Date
    Oct 2015
    Posts
    107
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Return Positive Value of SUMIF

    Another neat trick is to put a - in front of your Sumif. So =-SUMIF(U5:U91, "2", N5:N91)

  4. #4
    Board Regular
    Join Date
    Jul 2007
    Location
    Sydney
    Posts
    4,392
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Return Positive Value of SUMIF

    Another neat trick is to put a - in front of your Sumif. So =-SUMIF(U5:U91, "2", N5:N91)
    Or:

    =SUMIF(U5:U91,"2",N5:N91)*-1

    Note though that these will reverse the total so if it happens to be positive it will return a negative. Depends what the OP really wants I suppose.

Some videos you may like

User Tag List

Tags for this Thread

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
  •