# Formula to count number of times specific word used in column range

1. ## Formula to count number of times specific word used in column range

Is there any way to make a formula to count the number of times a specific word is found in a range of cells? EX: =count "agree"(C2-C10)" and this would return a number value for the number of cells with "agree" in cells C2-C10.

2. ## Re: Formula to count number of times specific word used in column range

=countif(C2:C10, "agree")

or

=countif(C2:C10, "*agree*")

... depending on what you want.

3. ## Re: Formula to count number of times specific word used in column range

you could also put what you are searching for in its own cell, and just reference that cell, for more flexability if needed

4. ## Re: Formula to count number of times specific word used in column range

Works perfectly - Thanks!
flammer4

5. ## Re: Formula to count number of times specific word used in column range

How did you know that I really wanted to just count the correct responses for each item in an "agree" - "disagree" test? I just included a line of correct answers for each item, and referenced that cell (for that column) to count the cells (in that column) with the correct answer. In other words, an item analysis!
Thanks a bunch.
flammer4

6. ## Re: Formula to count number of times specific word used in column range

How did you know that ...
After a while you get used to dealing with incomplete information ...

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1