Counting in a Multi-Select Cell While Having Additionally Criteria
I am having issues figuring out the correct formula to use when counting criteria in a multi-select cell while also capturing a specific criteria. Please see below my example.
The sheet I have below is derived from a Form. Within that form, individuals who submitted a response had the option to select a Sport with a checkbox. When the user selected a check box in the form, a drop down menu would appear for them to select a variety of different 'Support Areas' for that Sport. Their responses are collected in the cells titled "Support Areas XYZ". I need an equation that not only counts how many 'Support Areas' for each Sport they selected, but also which Region they identified coming from (Captured in Column titled 'Region'.
I am planning on using this equation on a separate sheet so it does not interfere with the original responses from the Form, but if I can get any assistance on the type of equation I should be using to capture this information, I would greatly appreciate it.
Would also be happy to further elaborate if needed!
Help Article Resources
Check out the Formula Handbook template!