Multi Select Column Stacked Bar Graph Formula
I am having trouble finding the correct formula to add a specific combination of multiselect selections that are entered in a row. For example, I want to count all instances of options a & b in a column. Also, in the same formula reference the status.
Below is the formula we are using to count this with one selection, but how do we add multiple selections?
=COUNTIFS($Department1:Department19, "Downstream CAM", $Status1:Status19, "Not Started")
Help Article Resources
Check out the Formula Handbook template!