SumIfs based on Multiple criteria

Options

Trying to sum up an amount based on 2 criteria's. i'm getting $0.0


=SUMIFS({Retainer/Deposit Forcasting Range 1}, {Retainer/Deposit Forcasting Range 3}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2023), {Retain/Dep Range 3}, "Deposit", {Retain/Dep Range 3}, "Retainer")

Best Answer

  • ginamt3
    ginamt3 ✭✭✭✭
    Answer ✓
    Options

    This formula worked


    =SUMIFS({Retainer/Deposit Forcasting Range 1}, {Retainer/Deposit Forcasting Range 3}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2023), {Retain/Dep Range 3}, "Deposit") + SUMIFS({Retainer/Deposit Forcasting Range 1}, {Retainer/Deposit Forcasting Range 3}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2023), {Retain/Dep Range 3}, "Retainer")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!