Filter and count unique data with multiple criteria

[einna77]

Hi, Please help. I need to know what formula I can use.. In the sample data, there are 2 columns: Qty and Product. I want to filter the unique product with a qty of 1, and at the same time, I want to know the sum of the filtered product. In the sample, there is a column that should be the answer.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1
2	1	A		A	3
3		B		C	3
4	1	C		D	2
5		D
6	1	A
7		B
8	1	C
9	1	D
10	1	A
11		B
12	1	C
13	1	D
Master

Cell Formulas
Range	Formula
D2:D6	D2	=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$2:$B$13)/($A$2:$A$13=1)/(ISNA(MATCH($B$2:$B$13,D$1:D1,0))),1)),"")
E2:E6	E2	=IF(D2<>"",SUMIFS(A:A,B:B,D2),"")

 

[einna77]

How about

Fluff.xlsm
	A	B	C	D	E
1
2	1	A		A	3
3		B		C	3
4	1	C		D	2
5		D
6	1	A
7		B
8	1	C
9	1	D
10	1	A
11		B
12	1	C
13	1	D
Master

Cell Formulas
Range	Formula
D2:D6	D2	=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$2:$B$13)/($A$2:$A$13=1)/(ISNA(MATCH($B$2:$B$13,D$1:D1,0))),1)),"")
E2:E6	E2	=IF(D2<>"",SUMIFS(A:A,B:B,D2),"")

Yehey. This what i'm looking for.
Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.