+ Reply to Thread
Results 1 to 6 of 6

Counting the number of occurrences of a character in one cell and a range

  1. #1
    Registered User
    Join Date
    11-19-2010
    Location
    NY, NY
    MS-Off Ver
    Excel 2007
    Posts
    4

    Counting the number of occurrences of a character in one cell and a range

    I am trying to count the number of "x" in one cell and in a range. I have a participant and place and x for the number of times I have followed up with that participant in one month then I have to sum the number of time I have followed up with all of the participants in the entire month.

    thanks

  2. #2
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Re: Counting the number of occurrences of a character in one cell and a range

    Hi welcome,

    Its best for those trying to help to have clear and detail explanation of your scenario. Attaching a small sample of your predicament and showing an example or two of your deisred results is more than welcome...

    Therefore, from your explanation we are not clear whether your "x"s are in the same cell with the name or on a different column. So see attached, sheet1 has the "x"s in the same cell and sheet2 on a different column. If this does not help you, or give you an idea of what to do with your actual workbook, attach something so we can help you.

    EDIT: Please note that with the example posed in sheet1, if the actual name of the participant has an "x" as part or their name. Then the formula will give erroneous results. We would have to modify the formula, but we'll wait until you give us some data.
    Attached Files Attached Files
    Last edited by ron2k_1; 11-19-2010 at 12:40 PM.
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

  3. #3
    Registered User
    Join Date
    11-19-2010
    Location
    NY, NY
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Counting the number of occurrences of a character in one cell and a range

    Sorry about the confusion. The name of the participate is in a different cell and column.

    Name of participant Follow-up Advocacy
    Smith, Joe xxxx xxx
    Doe, Jane x xx

    Totals 5 5

    I'm not sure how to get the totals. I have done the =countif(range,"x") for other forms but this won't count all of the x's in the same cell. (sorry, I am new to all of this including posting and I don't know how to upload an actual example.

    Thanks!!!

  4. #4
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Re: Counting the number of occurrences of a character in one cell and a range

    You may have to insert a helper column and then hide it. Look at Sheet2 of my attachment on the previous post.

  5. #5
    Registered User
    Join Date
    11-19-2010
    Location
    NY, NY
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Counting the number of occurrences of a character in one cell and a range

    There's no way to total the all of the "x" in column B on sheet 2 of your example?

    How do I insert a helper column and then hide it? Sorry that I'm so basic.

  6. #6
    Registered User
    Join Date
    11-19-2010
    Location
    NY, NY
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Counting the number of occurrences of a character in one cell and a range

    Never mind I figured it out! Thanks for your help!!!!!

+ 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