LinkBack URL
About LinkBacks
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.
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.
=countif(C2:C10, "agree")
or
=countif(C2:C10, "*agree*")
... depending on what you want.
Entia non sunt multiplicanda sine necessitate
you could also put what you are searching for in its own cell, and just reference that cell, for more flexability if needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Works perfectly - Thanks!
flammer4
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
After a while you get used to dealing with incomplete information ...How did you know that ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks