What would the formula look like if you had a third criteria?

"Bob Phillips" wrote:

=SUM(--(FREQUENCY(IF((B1:B6=0)*(C1:C6=3),MATCH(A1:A6,A1:A 6,0)),ROW(INDIRECT(
"1:"&ROWS(A1:A6))))0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rachel" wrote in message
...
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...