Count if

  • Thread starter Thread starter ecf123
  • Start date Start date
E

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
 
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)
 
=--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
 
Hi,

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

As asked you might write

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

or
 
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..
 
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..
 
Back
Top