Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    countif (excel2003)

    hi,
    members & viewers, it's been awhile , I missed you all.

    I need a help with a countif formula to count the number of times a code exist in a column. My difficulty is that the code is part of a name. example is
    the name in the column is Initial bottom(RM) ,what I want to count is (RM).
    Thanks in advance.
    TIA
    dubdub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: countif (excel2003)

    Assuming thay you want to count the number of times the values in A1:A100 end with "(RM)", you can use this array formule (it must be confirmed with Ctrl+Shift+Enter, not just Enter):
    <code>
    =SUM(1*(RIGHT($A$1:$A$100,4)="(RM)"))
    </code>
    Replace A1:A100 with the range in which you want to count. You can replace "(RM)" with a reference to a cell that contains "(RM)"

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: countif (excel2003)

    works fine.
    thanks Hans.
    TIA
    dubdub

  4. #4
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: countif (excel2003)

    =COUNTIF(Range,"*(RM)*")
    Microsoft MVP - Excel

Posting Permissions

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