SUMIFS Statements with less then percentage

Options

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

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!