+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    04-06-2012
    Location
    San Jose, CA
    MS-Off Ver
    Excel in Office 2011 for Mac
    Posts
    7

    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. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    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.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    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

  4. #4
    Registered User
    Join Date
    04-06-2012
    Location
    San Jose, CA
    MS-Off Ver
    Excel in Office 2011 for Mac
    Posts
    7

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

    Works perfectly - Thanks!
    flammer4

  5. #5
    Registered User
    Join Date
    04-06-2012
    Location
    San Jose, CA
    MS-Off Ver
    Excel in Office 2011 for Mac
    Posts
    7

    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. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    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 ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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