I’m trying to create a COUNTIF from a multiple drop down column (referencing another sheet). Two words are similar: Active and Inactive.
If I use CONTAINS, it counts both Active and Inactive: =COUNTIF({Certified Roster Range 1}, CONTAINS("Active", @cell))
If I use HAS, it counts when Active is the ONLY item listed in the drop down: =COUNTIF({Certified Roster Range 1}, HAS("Active", @cell))
What is the formula to count the word Active, even if there are other items listed in the drop down but exclude the word Inactive?
I really struggle with formulas. Thank you.