Tony and Phil will only appear once
"RagDyeR" wrote in message
...
What happens if you have *multiple* occurrences of "Tony" and "Phil"?

See if this works for you.

Will count *all* occurrences of "Tony" and "Phil" being on the same line
(row):

=SUMPRODUCT((A2:B11={"Tony","Phil"})*(A2:B11={"Phi l","Tony"}))

--

HTH,

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

"Phil" wrote in message
. uk...
Thanks, that works if the values Phil and Tony are in A1 or B1 but they
could be anywhere from A2 : A11 or B2 : B11
"Roger Govier" wrote in message
...
Hi Phil
In cell AA1
=AND(A1="phil",B1="Tony")+AND(A1="Tony",B1="Phil") *1

--
Regards

Roger Govier


"Phil" wrote in message
. uk...
I am trying to find a formula that looks at a range of cells, a2:b11,
and
if
a cell in the range has a value Phil and its adjacent cell in the
other
column
has a value Tony then AA1=1, if no adjacent cells match the criteria
AA1
=0. The names can be in either column.

For instance...

A B
Phil Tony would give AA1 value 1
Tony Phil would also give AA1 value 1
xxx yyy would give AA1 value 0

Thanks