Count if

[ecf123]

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

 

[Luke M]

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)

 

[Simon Lloyd]

I trying to count enties with different condition
exampl
if this A1=A2,1, if A1<>A2,0, if A2<>A3,
can somebody help me setting up this formul
-
Thanks ECFyou want to count entries where? in what range? where would you like th

formula to go

2 ways of doing it in B1 (or wherever
=IF(A1=A2,1,IF(A1<>A2,0,IF(A2<>A3,1,0))) or =IF(OR(A1=A2,A2<>A3),1,0

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Eduardo]

Hi,
if(OR(a1=a2,a2<>a3),1,0)

 

[RagDyeR]

=--OR(A1=A2,A2<>A3)
--

HTH,

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

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

 

[Shane Devenshire]

Hi,

Let me be a stickler - if A2=A3 what happens?

As asked you might write

=--AND(A1=A2,A2<>A3)

or

 

[David]

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

 

[RagDyeR]

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!
=====================================================


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