Try:

=SUM(IF(A1:A6=D1,IF(B1:B6=E1,1,0),0))

Where your list is in A & B
Where D1 is the color of the dog
Where E1 is the eye color

Use CTRL + SHIFT + ENTER to enter.

HTH
Regards,
Howard

wrote in message
oups.com...
I have two columns, one with dog color and the other with eye color. I
am trying to identify the number of grey dogs that have blue eyes. Dog
color is in one column, eye color is another. I'd be very grateful for
any help....just a PhD student trying to finish my dissertation.
thanks, judy
p.s. the specifics are made up but the problem has caused me an hour
and a half of frustration.