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.

Reputation: 1

Excel 2010 countif function

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:

I need to count every answer separately. How do I do that? Thanks.

Upvotes: 0

Reputation: 2355

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

=COUNTIF(A1:A10,"*melon*")

To know how many answers contain "melon" in range A1 to A10.

Upvotes: 1