I have the answers of a questionnaire and I need to translate the data. Some questions had multiple choice answers.
They appear like, for example:
- ”apple, cherry, banana, melon”
- ”berry, apple, melon”
- ...
I need to count every answer separately. How do I do that? Thanks.
The Countif function can have 2 arguments. The first is the range to search, the second is what to look for. Specifically, you can check this link, it is very well explained: https://exceljet.net/formula/count-cells-that-contain-specific-text
To know how many answers contain "melon" in range A1 to A10.