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?

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" <[email protected]> wrote in message
news:u%[email protected]...
> 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?
>
>
>

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

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

Jim /*



"Earl Kiosterud" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:u%[email protected]...
>> 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?
>>
>>
>>
>
>