Countif Help

[Carla]

Hi, I was wondering if its possible to use multiple
criteria when using the COUNTIF Function.

For example if I have a list of names and then a menu with
options that drops down in another column can I use
COUNTIF to get me a sum for a pecif name.?.?
A B
Mary cat
Carla cat
John dog
Mark bird
Carla dog
Carla cat

Right now I have =COUNTIF(B1:B100,"cat") which totals up
how many cats are chosen in column B, what I want is to
total up how many times "cat" is chosen only by "Carla"

Can this be done?
Puleeeeze help if you can..
Thanks

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(A1:A100="Carla"),--(B1:B100="cat"))

 

[DDM]

Carla, use the SUMPRODUCT worksheet function. So:

=SUMPRODUCT((A1:A100="Carla")*(B1:B100="cat"))