counting cells containing specific text

[ceds]

Hi,

I am trying to write a formula so that if three cells contain specific text, a number one will be put in a certain column.

For example:
Cell A1 contains an A
Cell B1 contains a B
Cell C1 contains a B

What formula would I need so that if this pattern exists a number 1 would appear in cell E1 for example?

Many thanks if you can help!

 

[Weaver]

I'd like to think there's a more elegant way (probably using array formula) but this appears to do the job:

=--AND(NOT(ISERROR(FIND("A",A1))),NOT(ISERROR(FIND("B",B1))),NOT(ISERROR(FIND("B",C1))))

If there's a match you get a 1, if all 3 conditions are not met, a zero is returned.

HTH

 

[HalfAce]

Hi ceds, welcome to the board.
I doubt your example is as simple as the real desire, but how about this to start? (In E1)

=(A1="A")*(B1="B")*(C1="B")

This will return a 1 in E1 if all are true, or a zero if all are not.

That help at all?

 

[ceds]

That's great, thanks both of you - both solutions will definitely help with what I'm looking to do.

Thanks again!