Results 1 to 6 of 6

Need to count number of occurrences of a word in a column

This is a discussion on Need to count number of occurrences of a word in a column within the Excel Questions forums, part of the Question Forums category; Column A has 100 entries (A2 through A101) Some of these entries are "Houston" What formula can I use to ...

  1. #1
    Board Regular
    Join Date
    Nov 2002
    Location
    New Orleans
    Posts
    62

    Default Need to count number of occurrences of a word in a column

    Column A has 100 entries (A2 through A101)
    Some of these entries are "Houston"

    What formula can I use to calc. how many times the word "Houston" appears within that Column so that I don't have to manually count each time???

    Thanks for any help.
    jase.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,950

    Default

    =COUNTIF(A1:A100,"Houston")
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Nov 2002
    Location
    New Orleans
    Posts
    62

    Default

    Geezum's -- you'd think I would have gotten that. I was close. Thanks a million.

    jase.

  4. #4
    New Member
    Join Date
    Oct 2009
    Posts
    1

    Default Re: Need to count number of occurrences of a word in a column

    I am also need to count the number of occurences of a particular word across various cells and columns in Excel, however in my case cells don't contain a single word but a large amount of text.


  5. #5
    New Member
    Join Date
    Apr 2011
    Posts
    1

    Default Re: Need to count number of occurrences of a word in a column

    Quote Originally Posted by Juan Pablo González View Post
    =COUNTIF(A1:A100,"Houston")
    Cool It really helped.

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    65,112

    Default Re: Need to count number of occurrences of a word in a column

    Quote Originally Posted by Cherique View Post
    I am also need to count the number of occurences of a particular word across various cells and columns in Excel, however in my case cells don't contain a single word but a large amount of text.

    Try...

    H2: manhattan

    I2:

    =COUNTIF(A1:F100,"*"&H2&"*")
    Assuming too much and qualifying too much are two faces of the same problem.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com