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
Check out the Formula Handbook template!