Listed price to know

[jibu08]

Hello guys,

Need your help as i need to know listed (repeated price) price for apple sold in 120203 which excel formula shall i use? i have large database with different product and market code... [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]

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1070859-sumifs-countif.html#post5143359

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).