sumproduct or countA, but how :)

[zyuth]

Fruits	Years
apple	2018
apple	2018
orange	2018
banana	2018
peach	2019
grape	2019
apple	2019
melon	2019
2018	3

<colgroup><col span="2"></colgroup><tbody>
</tbody>

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"