=SUMPRODUCT(--($A$1:$A$6="dog")*($B$1:$C$6<""))


"Rachel" wrote:

Hi,
I would like to count the number of unique entries in a column which meet
various criteria.
A B C
dog 0 3
dogs 0 4
cat 0 3
mice 1 4
cat 0 3
mouse 1 3


So, I would like all unique entries in column A, for which a "0" is
specified in col B and a "3" in col C. I am looking for "2" as a result here.

Thanks for any help...