Min formula with 2 criteria

[Ron99]

Hello,

I need a simple MIN formula with 2 criteria. Below Is the table

component	description	qty
a	systematic	10
d	non-systematic	62
c	systematic	84
b	systematic	56
d	systematic	3
b	non-systematic	1
a	non-systematic	9
c	systematic	84
b	systematic	25
f	non-systematic	9

<tbody>
</tbody>

I would like the formula to lookup criteria under column A and give me the min value only for systemic parts. example component A, SYSTEMATIC MIN value is 10

 

[Ron99]

I guess this worked for me. Thanks.

{=MIN(IF($A:$A=A2,IF($B:$B="SYSTEMATIC",$C:$C)))}

 

[Peter_SSs]

For a standard-entry formula try this, copied across

Excel Workbook
	A	B	C	D	E	F	G
1	component	description	qty		Component	a	b
2	a	systematic	10		Description	systematic	systematic
3	d	non-systematic	62		Minimum	10	25
4	c	systematic	84
5	b	systematic	56
6	d	systematic	3
7	b	non-systematic	1
8	a	non-systematic	9
9	c	systematic	84
10	b	systematic	25
11	f	non-systematic	9
Min