SumIFS from another sheet with two conditions

nermine.elsaghir

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!

DKazatsky2

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,

Dave

DKazatsky2

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,

Dave

nermine.elsaghir

@DKazatsky2 OMG Dave, It worked! I can't thank you enough! Thank you Thank you :)

DKazatsky2

@nermine.elsaghir

Glad to help.