Need formula to solve first occurance

Hello, I need two formulas to help me solve below scenario.

1. A sum for the first occurrence of total price of each item times the price, i.e. (apple will be 2). So there is two 5s in the price, how should i write a formula to omit the second 5?
2. A sum of the first occurrence of the total price of each item in the corresponding season, i.e.(watermelon in summer will be 5, watermelon in fall will be 10. In the above, watermelon will be 15 as it will not constitute the season).

Please help!

Items Season Price
Apple fall 2
peach summer 5
banana fall 3
watermelon summer 5
watermelon fall 10

Hi jnj,

I dont really understand what you want to achieve but try see attached file, if its doesnt solve your problem try to put your expected result and post it to the forum so it will be easier to understand.

Book2.xlsx

IMO you'll have to elaborate on your needs. To state you need as the sum of first occurence (i.e. singular, not plural as in more than one instance) is essentially a mathematical oxymoron. In mathematics terminology, the sum of first occurance is always the value of first occurence.

Agree with jhren.

@ jnj: please put your expected results manually on your sample sheets, and try to explain how you get that result, put more example on the sheet if necessary to explain the condition for your expected results.

thanks. works like magic!!