SUMIFS and OR Statements In one

Options

Hello, I am trying to create a formula which requires SUMIFS and OR statements. I am definitely not using them correctly and can use some help...

=COUNTIFS({GDP Project Tracker Range 1}, "M0", {GDP Project Tracker Range 3}, "1", {GDP Project Tracker Range 4} OR("Active", "Planned", "Launched"))

The first two parts work but as soon as I try and add the column with the or statement it doesn't. I need that last part to be within the selected range and any one of those three options would work. Any help would be appreciated!

Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!