COUNTIF

[JimNC]

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 Kiosterud]

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"))

 

[JimNC]

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

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

Jim /*