Min formula with 2 criteria

[Ron99]

Hello,

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

[TABLE="width: 184"]
<tbody>[TR]
[TD="width: 78, bgcolor: transparent"]component
[/TD]
[TD="width: 103, bgcolor: transparent"]description
[/TD]
[TD="width: 64, bgcolor: transparent"]qty
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]a
[/TD]
[TD="bgcolor: transparent"]systematic
[/TD]
[TD="bgcolor: transparent, align: right"]10
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]d
[/TD]
[TD="bgcolor: transparent"]non-systematic
[/TD]
[TD="bgcolor: transparent, align: right"]62
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]c
[/TD]
[TD="bgcolor: transparent"]systematic
[/TD]
[TD="bgcolor: transparent, align: right"]84
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]b
[/TD]
[TD="bgcolor: transparent"]systematic
[/TD]
[TD="bgcolor: transparent, align: right"]56
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]d
[/TD]
[TD="bgcolor: transparent"]systematic
[/TD]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]b
[/TD]
[TD="bgcolor: transparent"]non-systematic
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]a
[/TD]
[TD="bgcolor: transparent"]non-systematic
[/TD]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]c
[/TD]
[TD="bgcolor: transparent"]systematic
[/TD]
[TD="bgcolor: transparent, align: right"]84
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]b
[/TD]
[TD="bgcolor: transparent"]systematic
[/TD]
[TD="bgcolor: transparent, align: right"]25
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]f
[/TD]
[TD="bgcolor: transparent"]non-systematic
[/TD]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[/TR]
</tbody>[/TABLE]

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