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
-
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
Answers
-
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 OMG Dave, It worked! I can't thank you enough! Thank you Thank you :)
-
Glad to help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!