I need help with creating a formula using Countif or Countifs.
I am trying to pull data from one range that has mulitiple values. Does anyone know how to write a formula to not pull information from more than one range?
I am using the formula =countif(sheet reference data), (question ie: What do you enjoy most about your holiday party? @row.
This works for when the question isn't set up with multiple values. However I have the question from the picture that does have multiple values. How do I get it do count for example Dancing if it has the other values.
Can someone lead me in the right direction?
Help Article Resources
Check out the Formula Handbook template!