Countif Help

  • Thread starter Thread starter Carla
  • Start date Start date
C

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
 
Carla, use the SUMPRODUCT worksheet function. So:

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