• countif formula (excel 20000)

    Author
    Topic
    #367495

    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

    Viewing 0 reply threads
    Author
    Replies
    • #573116

      A missing ampersand:

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

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

      Ingrid

      • #573122

        Ingrid S
        thank you very much, it works wonderfully.

    Viewing 0 reply threads
    Reply To: countif formula (excel 20000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: