sumproduct or countA, but how :)

[zyuth]

[TABLE="width: 154"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]Fruits[/TD]
[TD]Years[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD="align: right"]2018[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD="align: right"]2018[/TD]
[/TR]
[TR]
[TD]orange[/TD]
[TD="align: right"]2018[/TD]
[/TR]
[TR]
[TD]banana[/TD]
[TD="align: right"]2018[/TD]
[/TR]
[TR]
[TD]peach[/TD]
[TD="align: right"]2019[/TD]
[/TR]
[TR]
[TD]grape[/TD]
[TD="align: right"]2019[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD="align: right"]2019[/TD]
[/TR]
[TR]
[TD]melon[/TD]
[TD="align: right"]2019[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

hi i got this case, can you help me out for the formula? as u can see the answer is 3, but when i change to 2019 the answer is 4. thanks

 

[Sam_D_Ben]

oh.. you are too specific by putting apple on it. what i want is how much fruit type in 2018 (or base on year that i will put)

I guess, "eating an Apple before going to bed and you"ll keep away the doctor from eating his bread"