Counting two unique based on third column

[creative999]

Hi,
Any suggestions on a formula which would count unique values from columns A and B based on column E = Yes.

The count in the attached example should be:
Stationary = 2
Furniture = 1

 

[dreid1011]

Why would Stationary count as 2 with columns A and B? Are you looking for each unique combination of A and B where E = Yes? Does column C come in to play at all?

 

[creative999]

Why would Stationary count as 2 with columns A and B? Are you looking for each unique combination of A and B where E = Yes? Does column C come in to play at all?

Sorry, it should say:

'which would count unique values from columns A and C based on column E = Yes

 

[felixstraube]

How about ?:

Libro1.xlsx
	A	B	C	D	E	F	G	H
1	Stationary		in		yes
2	Stationary		in		yes
3	Stationary		out		yes
4	Stationary		out
5	Stationary		out		yes
6	Stationary		out
7	Furniture		ABC		yes
8	Furniture		ABC		yes
9	Furniture		ABC		yes
10	Furniture		ABC		yes
11	Furniture		ABC		yes
12
13							Stationary	2
14							Furniture	1
Sheet1

Cell Formulas
Range	Formula
H13:H14	H13	=IFERROR(COUNTA(UNIQUE(FILTER($C$1:$C$11,($E$1:$E$11="yes")*($A$1:$A$11=G13)))),0)

 

[creative999]

Perfect - thank you so much

 

[creative999]

Im trying to add another condition, but even when theres no match, im getting a value of 1.

=IFERROR(COUNTA(UNIQUE(FILTER($C$1:$C$11,($E$1:$E$11="yes")*($A$1:$A$11=G13)*($D$1:$D$11="YES")))),0)

 

[felixstraube]

There was a problem.
I think this works correctly:

Libro1
	A	B	C	D	E	F	G	H
1	Stationary		in	yes	yes
2	Stationary		in	yes	yes
3	Stationary		out	yes	yes
4	Stationary		out
5	Stationary		ABC	yes	yes
6	Stationary		gh	yes	yes
7	Furniture		ABC	yes	yes
8	Furniture		ABC	yes	yes
9	Furniture		GH		yes
10	Furniture		BD	yes	yes
11	Furniture		ABC	yes	yes
12
13							Stationary	4
14							Furniture	2
Hoja1

Cell Formulas
Range	Formula
H13:H14	H13	=LET( d,UNIQUE(FILTER($C$1:$C$11,($E$1:$E$11="yes")*($A$1:$A$11=G13)*($D$1:$D$11="yes"))), IF(ISERROR(SUM(d)),0,COUNTA(d)) )