Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Countif (Excel )

    Hi all,

    I have a formula that isn't working, I want to count a column on another sheet in the same workbook, but it isnt' working.

    Would there be reason as to why I Countif doesn't work?

    =COUNTIF(Logs!F2:F1002,"F")


    Thanks
    Darryl.
    Darryl.

  2. #2
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Countif (Excel )

    Thanks all......I had a character space in there that I shouldn't [img]/forums/images/smilies/smile.gif[/img]

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Countif (Excel )

    There is nothing wrong with your formula...I tried it and it works in my workbook!
    Check for spaces in your sheet name and make sure that the letter F occurs in column F of the Logs sheet!

    What is the error output. #Val, #Num...or just 0 ???
    Regards,
    Rudi

Posting Permissions

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