SumIFS from another sheet with two conditions

I am trying to use the SUMIFS function to sum the total budget approved for one of the Functions when the STEP is only In-Flight. This is the formula I am using, but it's not working!

=SUMIFS({Projects Function}, CONTAINS("Finance"), {Projects Step}, CONTAINS("6 - In Flight"), {Budget}, >25)

I need the data from another sheet, and from three columns.

Thanks in advance!

Best Answer

  • DKazatsky2
    DKazatsky2 ✭✭✭✭✭
    Answer ✓

    Hi @nermine.elsaghir ,

    It looks like you are missing the range of what you want summed, which I assume is {Budget} - this should be the first argument in the formula. Additionally, is the values you are are using for your criteria are the entire values of the cell, you do not need to use "CONTAINS" (again, I am making an assumption that this is the case).

    Try this: =SUMIFS({Budget}, {Projects Function}, "Finance", {Projects Step}, "6 - In Flight", {Budget}, >25)

    Hope this helps,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!