How to count number of expression in excell?

[fatima777]

I am working in a very large excell file that does not contain numerical values ​​but expressions such as:
I do not agree
I agree
I agree very much


And so on

I want to count the number of times the expression "agree" appears in the table


What function should I use? and how?

66.png

[etaf]

something like
=COUNTIF(A1:J100,"*agree*")

I'm in UK and only understand english
you may need to post in the foreign forum

Note: Images are difficult to see , and also requires that I input all the data myself, which is very time consuming.

A sample sheet would help here


Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[MrShorty]

Your text "responses" suggest that you are analyzing survey type data. This is more about the statistics rather than Excel, but my first thought with such survey data is to use Likert scales and analysis (maybe a good starting point: http://www.kenpro.org/how-to-conduct...cale-analysis/ ). One of the key first steps in Likert analysis is to assign an appropriate numeric value to each response text (a lookup function in Excel should make quick work of this). Then you have numbers you can analyze (calculating means as in the kenpro link, for example). If you want to count responses, you can use variations on etaf's COUNTIFS() function. One of the advantages with the Likert numeric scale is that your criteria are going to be simpler numeric criteria rather than more complicated text (often with wildcards as etaf shows).

It really depends on how much statistics you want to involve. If you're only interested in the answer to the surface question you asked, etaf's solution should be a good starting place. If you are interested in some of the statistical questions behind your surface question, learning and understanding Likert scale analysis should add to your analyses.