You probably have invisible characters *after* the final "P".

Maybe <Space or the non-breaking, often used web space, Char(160).

Do a character count of one of the cells in question,
=Len(a1)
and compare the number to what you can see.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"David" wrote in message
...
Hi,

I am trying to count the cells in a column ending with a particular letter.
Cells contain alphanumeric values. For ex: =COUNTIF(W5:W7,"*P") This is
giving zero as the answer instead of 2. Please help..


"Luke M" wrote:

You might want to take a look at the OR/AND functions (XL help file). For
what you have so far:
=IF(OR(A1=A2,A2<A3),1,0)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ecf123" wrote:

I trying to count enties with different conditions
example
if this A1=A2,1, if A1<A2,0, if A2<A3,1
can somebody help me setting up this formula
--
Thanks ECF