Count number of lines based on text and number criteria, without duplicates

[HVCompleto]

Hello! New user here!
I've been trying to figure out for a day and can't seem to find any help on any thread for this, so I decided to post a new one.
Below is the sample database for my problem. The final goal is to have a cell that returns the number of times a unique brand (Column A with no duplicates) is in Store (column B = YES) and with values below 0 (Column C <0).
So in this case, the cell should return 3!

Brand	In store?	Value
3m	yes	-300
3m	no	0
3m	yes	-233
3m	no	200
aeg	yes	0
aeg	no	-200
aeg	yes	-300
aeg	no	-200
bosch	yes	-100
bosch	no	0
bosch	yes	-50
bosch	no	-500
osaka	yes	0
osaka	no	-20
osaka	yes	0
osaka	no	-100

<tbody>
</tbody>

 

[Weazel]

maybe something like...

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
1	Brand	In store?	Value
2	3m	yes	-300		3
3	3m	no	0
4	3m	yes	-233
5	3m	no	200
6	aeg	yes	0
7	aeg	no	-200
8	aeg	yes	-300
9	aeg	no	-200
10	bosch	yes	-100
11	bosch	no	0
12	bosch	yes	-50
13	bosch	no	-500
14	osaka	yes	0
15	osaka	no	-20
16	osaka	yes	0
17	osaka	no	-100

<tbody>
</tbody>

Sheet1​

Array Formulas Cell Formula E2 {=SUM(IF(FREQUENCY(IF(A2:A17<>"",IF(B2:B17="yes",IF(C2:C17<0,MATCH(A2:A17,A2:A17,0)))),ROW(A2:A17)-ROW(A2)+1),1))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[HVCompleto]

Thank you!!

I need to learn how to work with array formulas, they're so helpful!!
This works perfectly!