# COUNTIF

1. ## 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. ## 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
-------------------------------------------

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. ## 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?
>>
>>
>>

>
>

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

#### 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