+ Reply to Thread
Results 1 to 3 of 3

COUNTIF

  1. #1
    JimNC
    Guest

    COUNTIF

    Why does COUNTIF see "01" and "1" in text formatted cells as equals? I need
    them to be seen as different. These should be evaluated as different in text
    formatted cells. In numeric formatted cells the leading "0" would not be
    displayed.

    In this same text formatted column, "99" is left justified and "999" is
    right justified. Why?




  2. #2
    Earl Kiosterud
    Guest

    Re: COUNTIF

    Jim,

    Try
    =SUMPRODUCT(--(A1:A20="01"))
    =SUMPRODUCT(--(A1:A20="1"))

    or entered as array formulas (Ctrl - Shift - Enter):

    =SUM(--(A1:A20="01"))
    =SUM(--(A1:A20="1"))

    --
    Earl Kiosterud
    mvpearl omitthisword at verizon period net
    -------------------------------------------

    "JimNC" <jward@advanceddesignsinc.com> wrote in message
    news:u%23xDIcCGFHA.1348@TK2MSFTNGP14.phx.gbl...
    > Why does COUNTIF see "01" and "1" in text formatted cells as equals? I
    > need them to be seen as different. These should be evaluated as different
    > in text formatted cells. In numeric formatted cells the leading "0" would
    > not be displayed.
    >
    > In this same text formatted column, "99" is left justified and "999" is
    > right justified. Why?
    >
    >
    >




  3. #3
    JimNC
    Guest

    Re: COUNTIF

    Earl, you were on the right track. I found this to work in my app.

    =SUMPRODUCT(--($C$6:$C$48=C6))

    Jim /*



    "Earl Kiosterud" <nothanks@nospam.com> wrote in message
    news:uIzb$9DGFHA.2824@tk2msftngp13.phx.gbl...
    > Jim,
    >
    > Try
    > =SUMPRODUCT(--(A1:A20="01"))
    > =SUMPRODUCT(--(A1:A20="1"))
    >
    > or entered as array formulas (Ctrl - Shift - Enter):
    >
    > =SUM(--(A1:A20="01"))
    > =SUM(--(A1:A20="1"))
    >
    > --
    > Earl Kiosterud
    > mvpearl omitthisword at verizon period net
    > -------------------------------------------
    >
    > "JimNC" <jward@advanceddesignsinc.com> wrote in message
    > news:u%23xDIcCGFHA.1348@TK2MSFTNGP14.phx.gbl...
    >> Why does COUNTIF see "01" and "1" in text formatted cells as equals? I
    >> need them to be seen as different. These should be evaluated as different
    >> in text formatted cells. In numeric formatted cells the leading "0" would
    >> not be displayed.
    >>
    >> In this same text formatted column, "99" is left justified and "999" is
    >> right justified. Why?
    >>
    >>
    >>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1