SUMIFS Statements with less then percentage
Hello!
I am looking for some help with my Smartsheet's formula below:
=SUMIFS({GDP Project Tracker Range 1}, {GDP Project Tracker Range 2}, "1", {GDP Project Tracker Range 4}, "<=2", {GDP Project Tracker Range 3}, "Active") + SUMIFS({GDP Project Tracker Range 1}, {GDP Project Tracker Range 2}, "1", {GDP Project Tracker Range 4}, "<=2", {GDP Project Tracker Range 3}, "Launched") + SUMIFS({GDP Project Tracker Range 1}, {GDP Project Tracker Range 2}, "1", {GDP Project Tracker Range 4}, "<=2", {GDP Project Tracker Range 3}, "Planned")
My goal is for the formula is for it to look down the entire first column and only display results for a "1", Second part is to search down a different column and only display results if it is less then 2%, and then search down a third column and display results if it is planned, active, or launched.
If anyone could help me at all or create the right code, I would really appreciate it. I have been struggling for a couple hours now without any progress!
Thank you!
Answers
-
2% is actually treated as 0.02. You can also avoid the repetition and math by using an OR statement.
=SUMIFS({GDP Project Tracker Range 1}, {GDP Project Tracker Range 2}, "1", {GDP Project Tracker Range 4}, "<= 0.02", {GDP Project Tracker Range 3}, OR(@cell = "Active", @cell = "Launched", @cell = "Planned"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!