SUMIFS and OR Statements In one

EMueller

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!

Paul Newcome

You need to use "@cell" references.

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