Improper Value with my Code!

Hello!

I'm needing some help with my Smartsheet's formula. For whatever reason I do not know I get a totally wrong number although I believe it is correct. Any help would be appreciated!

=SUMIFS({GDP Project Tracker Range 1}, {GDP Project Tracker Range 5}, "<0.05", {GDP Project Tracker Range 3}, "Active") + SUMIFS({GDP Project Tracker Range 1}, {GDP Project Tracker Range 5}, "<=0.05", {GDP Project Tracker Range 3}, "Launched") + SUMIFS({GDP Project Tracker Range 1}, {GDP Project Tracker Range 5}, "<=0.05", {GDP Project Tracker Range 3}, "Planned")

I want the sheet to look for everything less then 5% in one column and then display results if it is active, launched, and planned. If I change that first range statement from 1 to something else i get even crazier values. Please help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!