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
|