+ Reply to Thread
Results 1 to 5 of 5

How do i get excel to count the number of times a word appears in a range of cells?

  1. #1
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    83

    How do i get excel to count the number of times a word appears in a range of cells?

    I have a column of cells in which there are some numbers and some words. I need to know how to get Excel to count how many times a certain word appears .
    Last edited by davidcrawt; 07-05-2017 at 06:33 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: How do i get excel to count the number of times a word appears in a range of cells?

    What happens if the word appears more than once in the same cell?
    Do you want an indicator that the word appears in that cell or the total number of occurrences in that cell?

    Your description is therefore not clear enough so please provide some sample data with expected results.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    83

    Re: How do i get excel to count the number of times a word appears in a range of cells?

    OK, I have a column of cells. Some of them have numbers in them and some have the word 'Oyster'. I want a formula which tells me have many cells in the range have the word 'Oyster' in them.

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: How do i get excel to count the number of times a word appears in a range of cells?

    TRY
    =COUNTIF(A1:A100,"*Oyster*")
    OR
    =COUNTIF(A1:A100,"Oyster")
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    83

    Re: How do i get excel to count the number of times a word appears in a range of cells?

    It's OK, I have now worked it out myself. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count number of times a specific word appears
    By csepesy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2017, 09:48 PM
  2. [SOLVED] Count the number of times a date appears in a range
    By uhtfgy in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-12-2015, 05:53 AM
  3. [SOLVED] count number of times a word appears
    By m_789 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-19-2013, 10:16 AM
  4. count the number of times a number appears in a specific range
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2013, 11:01 AM
  5. [SOLVED] Want to count the number of times a particular letter appears within a range
    By dwhite30518 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-11-2013, 01:24 PM
  6. Count how many times a number appears within a range of two numbers
    By Maristar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2009, 10:56 AM
  7. count the number of times a specific word appears in a column
    By BAR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 12:10 PM

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