SUMIFS or countif ???

[jibu08]

Good day.
Need to know price of apple in 120203... what excel formula shall i use??? i have large database with different product code as well as market code!!!

Product Code	Product name	price	market code
001	apple	2.00	120203
001	apple	2.00	120203
001	apple	3.00	120203
001	apple	3.00	120202
001	apple	2.00	120203
001	apple	2.00	120201

<tbody>
</tbody>

 

[Aladin Akyurek]

What the result you want to obtain?

 

[jibu08]

the result i want is price for apple sold in 120203, as i know 120203 is selling at 2 but in large database i want fix price or repeated price for an item

 

[Aladin Akyurek]

the result i want is price for apple sold in 120203, as i know 120203 is selling at 2 but in large database i want fix price or repeated price for an item

What is the result you want to obtain for apple associated with the market code 120203 for the sample you posted?