Count if
 

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

Count if
 

Hi,
try

=SUMPRODUCT(--(A2:A6="Robert")*(B2:B6="Robert"))

change range to fit your needs

"Robert" wrote:

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

Count if
 

=SUMPRODUCT((A1:A100="Robert") * (B1:B100="Robert"))

--
Gary''s Student - gsnu200907

Count if
 

=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

Count if
 

What is the double unary minus doing for you in this situation, Eduardo?
Isn't --1 the same as 1, and --0 the same as 0?
--
David Biddulph

"Eduardo" wrote in message
...
Hi,
try

=SUMPRODUCT(--(A2:A6="Robert")*(B2:B6="Robert"))

change range to fit your needs

"Robert" wrote:

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

Count if
 

Hi David,
you are right, I was in excel and just enter the double unary, isn't doing
anything

"David Biddulph" wrote:

What is the double unary minus doing for you in this situation, Eduardo?
Isn't --1 the same as 1, and --0 the same as 0?
--
David Biddulph

"Eduardo" wrote in message
...
Hi,
try

=SUMPRODUCT(--(A2:A6="Robert")*(B2:B6="Robert"))

change range to fit your needs

"Robert" wrote:

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