Formula to add multiple dropdown with a criteria

vhoyos

Example 

Column 1

banana

orange

watermelon

 

Column 2 

kid 1

kid 2

kid 3

 

I want to create an equation that counts, how many times kid 1 has chosen banana and orange???

 

Paul Newcome

You would use something along the lines of...

 

=COUNTIFS([Column 2]:[Column 2], "kid 1", [Column 1]:[Column 1], AND(CONTAINS("banana", @cell), CONTAINS("orange", @cell)))