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={"Phil","Tony"}))

--

HTH,

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

"Phil" <mrnw31666@blue.co.uk> wrote in message
news:XxMHe.81349$G8.48398@text.news.blueyonder.co.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" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:%23%23r0GY3lFHA.1372@TK2MSFTNGP10.phx.gbl...
> Hi Phil
> In cell AA1
> =AND(A1="phil",B1="Tony")+AND(A1="Tony",B1="Phil")*1
>
> --
> Regards
>
> Roger Govier
>
>
> "Phil" <someone@home.sometimes.uk> wrote in message
> news:o5MHe.81329$G8.58682@text.news.blueyonder.co.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
> >
> >
> >
> >
> >
>
>