Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Count if

14 views
Skip to first unread message

ecf123

unread,
Jul 20, 2009, 11:16:02 AM7/20/09
to
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

Luke M

unread,
Jul 20, 2009, 11:33:01 AM7/20/09
to
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!*

Simon Lloyd

unread,
Jul 20, 2009, 11:36:56 AM7/20/09
to
> Thanks ECFyou want to count entries where? in what range? where would you like the
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 Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=117750

Eduardo

unread,
Jul 20, 2009, 11:39:01 AM7/20/09
to
Hi,
if(OR(a1=a2,a2<>a3),1,0)

RagDyeR

unread,
Jul 20, 2009, 11:55:29 AM7/20/09
to
=--OR(A1=A2,A2<>A3)
--

HTH,

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

"ecf123" <ecf...@discussions.microsoft.com> wrote in message
news:9BCB2FDF-1D0C-4FE2...@microsoft.com...

Shane Devenshire

unread,
Jul 20, 2009, 4:10:01 PM7/20/09
to
Hi,

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

As asked you might write

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

or


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

David

unread,
Jul 24, 2009, 3:33:03 AM7/24/09
to
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

unread,
Jul 24, 2009, 12:12:02 PM7/24/09
to
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" <Da...@discussions.microsoft.com> wrote in message
news:49E4B676-43C2-4EF8...@microsoft.com...

0 new messages