Counting cells with multiple conditions

[stevemyers]

I need a formula that will check multiple conditions.....

A B
1 Bob Car
2 Dave Truck
3 Mary Car
4 Bob Car
5 Carl Truck
6 Dave Car
7 Bob Truck

In the above example I want to look at column A and find everywhere there is a "Bob" and "Dave" then I want to compare it to column B, and wherever "Bob" or "Dave" match "Car" it equals one. The results of the above would equal 3 (Rows 1,4,6 match the criteria)

Thanks in advance

[daddylonglegs]

Try like this

=SUMPRODUCT((A1:A10="Bob")+(A1:A10="Dave"),(B1:B10="Car")+0)

[stevemyers]

Another wrinkle... (changes in RED)
I need a formula that will check multiple conditions.....

A B
1 Bob Car
2 Dave Truck
3 Mary Car - Small
4 Bob Car - Small
5 Carl Truck
6 Dave Car - Big
7 Bob Truck

In the above example I want to look at column A and find everywhere there is a "Bob" and "Dave" then I want to compare it to column B, and wherever "Bob" or "Dave" match "Car", or "Car - Big", or "Car - Small" it equals one. The results of the above would equal 3 (Rows 1,4,6 match the criteria)

Thanks in advance