Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible.

2»

Answers

  • I do have one last question. Lets say that I want to select the paid date for just 2023 how do I add this to this formula? I do have a Paid Date column on the sheet as well.

  • KPH
    KPH ✭✭✭✭✭✭

    Phew 😌

    🥳

    Can you mark the comment from 11:59AM as the answer. Everything after that was just understanding some features specific to your sheet. Anyone with a similar problem should find the answer they need in that comment.

    You enjoy your day, you did it! 💃

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    For your follow up.

    1. You have a formula that is summing the deal value where Inspection Type is a certain value, Contract Stage is one of two values. This is good.
    2. You want to do something with Paid Date in 2023.

    Is Paid Date a date column?

    Do you still want to sum the deal value?

    If so, you can add an additional range and criteria to your SUMIFS.

    First you need a formula to find the year from your Paid Date.

    Then you put this into the SUMIFS (after an extra comma).

    Like this:

    =SUMIFS([Deal Value]:[Deal Value], [Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], OR(@cell = "7. Paid", @cell = "8. Commissioned"), [Paid Date]:[Paid Date], YEAR(@cell) = "2023")

  • This is a HUGE help! Thank you so much for your assistance.

  • KPH
    KPH ✭✭✭✭✭✭

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!