New filter formula, add additional criteria

[Razzy]

Sample.xlsx
	A	B	C	D	E
1	Quantity	A (m)	B (m)	Hight (m)	Type
2	1	0,3	0,2	3,34	F
3	15	0,3	0,1	2,19	O1
4	4	0,3	0,5	3,34	F
5	5	0,3	0,6	1,5	F
6	1	0,3	0,5	1	F
7	1	0,4	0,8	1,5	F
8	32	0,3	0,6	1	R
9	1	0,3	0,5	1	F
10
11
12					4
Ark1 (2)

Cell Formulas
Range	Formula
E12	E12	=COUNT(UNIQUE(FILTER((B2:B9^2+C2:C9^2)^2*D2:D9,A2:A9>=2)))

Question:
How to add an additional criterion in the filter function? So that the formula returns only for type F.

My rookie suggestion (adding an "AND" situation, did not work):

Sample.xlsx
	E
12	0
Ark1 (2)

Cell Formulas
Range	Formula
E12	E12	=COUNT(UNIQUE(FILTER((B2:B9^2+C2:C9^2)^2*D2:D9,AND(A2:A9>=2),E2:E9="F")))

hm...

 

[Razzy]

Maybe countifs, hm...

 

[jasonb75]

Just a guess

=COUNT(UNIQUE(FILTER(((B2:B9^2+C2:C9^2)^2*D2:D9,A2:A9>=2)*(E2:E9="F"))))

 

[Fluff]

How about
=COUNT(UNIQUE(FILTER((B2:B9^2+C2:C9^2)^2*D2:D9,(A2:A9>=2)*(E2:E9="F"))))

 

[jasonb75]

Oops, I missed the comma

 

[Razzy]

Just a guess

=COUNT(UNIQUE(FILTER(((B2:B9^2+C2:C9^2)^2*D2:D9,A2:A9>=2)*(E2:E9="F"))))

How about
=COUNT(UNIQUE(FILTER((B2:B9^2+C2:C9^2)^2*D2:D9,(A2:A9>=2)*(E2:E9="F"))))

Again, thank you very much.

I will try to make my questions as understandable and meaningful as possible, so that the forum gets something in return for their great efforts.

Thanks! ?

 

[Fluff]

Glad we could help & thanks for the feedback.