sumproduct will do it for you
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
paul
remove nospam for email addy!



" wrote:

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.