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!!!


[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Product Code[/TD]
[TD]Product name[/TD]
[TD]price[/TD]
[TD]market code[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]3.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]3.00[/TD]
[TD]120202[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120203[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]apple[/TD]
[TD]2.00[/TD]
[TD]120201



[/TD]
[/TR]
</tbody>[/TABLE]

 

[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?