COUNTIFS with HAS Referencing Another Sheet
Good morning, Community! I'm struggling with a formula and could use some help.
On the **CBO CBA Case Tracker sheet, the Priority populations served column is a multi-select with 21 options. The Priority Populations Served sheet has a Population column with each of the 21 values as I thought it would be easier to reference. On the **CBO CBA Case Tracker sheet, in A or B, I want to count the number of occurrences for each of the 21. Thinking B was the better place, I have space for all 21 but with the current formula, it's returning "0".
To test what the value should be, I filtered the sheet for the first one and there are 20 rows containing the first one (Aging/Older Populations).
What am I doing wrong?
Help Article Resources
Check out the Formula Handbook template!