This article was created from a community discussion.
How can my COUNTM Formula only capture those projects where efficiency gain is 1 of the benefits selected for that project. Project currently have more than 1 benefit such as "Efficiency Gain".
I am currently entering the formulas below, but not sure what else to do.
=COUNTM({MH-Work Prioritization Log Range 2}, {Benefits}, "Reduce Internal Pain Point")
=COUNTM({Benefits}, "Efficiency Gain")
Answer
I would have expected your first countifs in the post above would have worked - although you don't need the HAS function with your Status column since it's not a multi-select column, you should be able to just use "In Progress". To verify - your {Benefits} range and {MH-Work Prioritization Log Range 1} is on the same sheet? If yes, your {MH-Work Prioritization Log Range 1} is equal to the Status column?
I am assuming you're getting zero as your response instead of an error message? Or a count value that is not the expected result?
As a test, remove the Benefits and it's criteria from your COUNTIFS. What value does it give you- use your first formula above?