That formula has 2 criteria:

(B1:B6=0)*(C1:C6=3)

To add another criteria just follow the same pattern:

(B1:B6=0)*(C1:C6=3)*(criteria 3)

--
Biff
Microsoft Excel MVP


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