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

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>

 

[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).