Excel 2010 countif function

58 views Asked by At

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.

1

There are 1 answers

2
David G On

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.