=SUMPRODUCT((A1:A21="robert")*(B1:B21="robert"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robert" wrote in message
...
Hi,

I am trying to count the number of individuals in two seperate columns on
the same spreadsheet:
For exemple, in my column A, some cells have "Robert" and in Column B,
some
cells have "Robert". I want to know how many times we have "Robert" side
by
side.
Cell A1 = Robert and Cell B1 = Robert
I dont want to count all the other cells where Robert is shown but not
beside another Robert

Many Thanks

Robert