Results 1 to 6 of 6

Thread: COUNTIF Problem

  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good evening

    I am tring to use counif to find the number of times a word appears in a particular column by using =COUNTIF(C8:C1074,"ARCGLI") but it always returns 0 when I know there to be 10, can you see what I have done wrong?
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    =COUNTIF(C8:C1074,"ARCGLI")

    Will count the number of cells that are ="ARCGLI' not just contained. Are you perhaps desiring:

    =COUNTIF(C8:C1074,"*ARCGLI*")

    which look at the number of cells containing "ARCGLI"?

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Your formula works for me (2002) Steve, if the cell EQUALS ="ARCGLI", but not CONTAINS.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I don't understand why not. Could you post an example file?

    Steve

  5. #5
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='sdckapr' post='777047' date='26-May-2009 20:11']I don't understand why not. Could you post an example file?

    Steve[/quote]
    We cross-posted. I was talking to the other Steve, your formula works for me Steve.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    [quote name='VegasNath' post='777049' date='26-May-2009 15:15']We cross-posted. I was talking to the other Steve, your formula works for me Steve. [/quote]

    Ah-Ha, it all falls into place, now....

    Steve

Posting Permissions

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