Counting two columns with specific criteria
 

In column A I have a list of FIRST names and in column B I have a list
of LAST names.

How can I count the number of people with "SMITH" as the LAST name
ONLY if they have "BOB" as a FIRST name?

I have a tried a few things but have got a bit of brain freeze...

Any suggestions?

Thanks

Richard

Counting two columns with specific criteria
 

Hi,

Try this

=SUMPRODUCT((A1:A20="Bob")*(B1:B20="Smith"))

Mike

"rjre" wrote:

In column A I have a list of FIRST names and in column B I have a list
of LAST names.

How can I count the number of people with "SMITH" as the LAST name
ONLY if they have "BOB" as a FIRST name?

I have a tried a few things but have got a bit of brain freeze...

Any suggestions?

Thanks

Richard

Counting two columns with specific criteria
 

THANKS!

i had no idea i that function worked on text! FANTASTIC!



On Feb 13, 11:09*am, Mike H wrote:
Hi,

Try this

=SUMPRODUCT((A1:A20="Bob")*(B1:B20="Smith"))

Mike



"rjre" wrote:
In column A I have a list of FIRST names and in column B I have a list
of LAST names.

How can I count the number of people with "SMITH" as the LAST name
ONLY if they have "BOB" as a FIRST name?

I have a tried a few things but have got a bit of brain freeze...

Any suggestions?

Thanks

Richard- Hide quoted text -

- Show quoted text -

Counting two columns with specific criteria
 

Glad I could help

"rjre" wrote:

THANKS!

i had no idea i that function worked on text! FANTASTIC!



On Feb 13, 11:09 am, Mike H wrote:
Hi,

Try this

=SUMPRODUCT((A1:A20="Bob")*(B1:B20="Smith"))

Mike



"rjre" wrote:
In column A I have a list of FIRST names and in column B I have a list
of LAST names.

How can I count the number of people with "SMITH" as the LAST name
ONLY if they have "BOB" as a FIRST name?

I have a tried a few things but have got a bit of brain freeze...

Any suggestions?

Thanks

Richard- Hide quoted text -

- Show quoted text -