Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2002
    Location
    US
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    countif formula (excel 20000)

    Could someone please tell me what is wrong with this formula
    =countif(A:A,">b1")
    where I want to count how many items from column A that are greater thant the value in b1.
    thank you

  2. #2
    Lounger
    Join Date
    May 2001
    Location
    the Netherlands
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: countif formula (excel 20000)

    A missing ampersand:

    =countif(A:A;">"&B1)

    (smicolon or comma depending on your standard list deparator).

    Ingrid

  3. #3
    Lounger
    Join Date
    Feb 2002
    Location
    US
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: countif formula (excel 20000)

    Ingrid S
    thank you very much, it works wonderfully.

Posting Permissions

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