Home > Enterprise >  How to count values if option checked is selected in one cell
How to count values if option checked is selected in one cell

Time:03-10

I have a spreadsheet where users fill out a form, they have multiple options they can pick by clicking the checkboxes.

The responses sheets looks like this

enter image description here

I want to filter the results by option, so my main goal is to get the total amount of options selected: enter image description here

I've been trying with COUNTIF but it's not working because I'm not selecting the specific response

=COUNTIF('Form Responses 1'!C2:F4,"*"&$B$1&"*")

I'm assuming I need to add a VLOOKUP but I'm not sure how to match it with the option

Here's a enter image description here

  • Related