Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Please Help =IF(SUMIFS (Returning #Incorrect Argument Set)

Options

 

IF(SUMIFS(Status2, "WON", [Probability Hit Rate]2, "1", [Value Of Jobs]2))

Comments

  • Mitch.Shaffer
    Mitch.Shaffer ✭✭
    edited 07/17/17
    Options

    Remove the IF statement at the beginning, move the sum range to the first part of the formula (Value of Jobs), and change the criteria to a range.

    =SUMIFS([Value Of Jobs]:[Value Of Jobs], [Status]:[Status], "WON", [Probability Hit Rate]:[Probability Hit Rate], "1")

  • Thanks Mitch for your help. Two quick questions if i could please ...

    Cell returns $0.00, if i need it to return blank cell ("")

    =SUMIFS([Value Of Jobs]2:[Value Of Jobs]100, Status2:Status100, "WON", [Probability Hit Rate]2:[Probability Hit Rate]100, "1")

    Left out thrid criterion, when added in #UNPARSEABLE

    =SUMIFS(Value Of Jobs]2:[Value Of Jobs]100, [Assigned Too]2:[Assigned Too]100,”Heath”,[Status2:Status100, "WON", [Probability Hit Rate]2:[Probability Hit Rate]100, "1")

    Thanks for your help Mitch

     

  • Mitch.Shaffer
    Options

    Give this a try.

    =IF(SUMIFS([Value Of Jobs]2:[Value Of Jobs]100, [Status2]2:[Status2]100, "WON", [Assigned To]2:[Assigned To]100, "Heath", [Probability Hit Rate]2:[Probability Hit Rate]100, "1") = 0, "", (SUMIFS([Value Of Jobs]2:[Value Of Jobs]100, [Status2]2:[Status2]100, "WON", [Assigned To]2:[Assigned To]100, "Heath", [Probability Hit Rate]2:[Probability Hit Rate]100, "1")))

This discussion has been closed.