So my suggestion is here.
In every column of your table the results are with formulae, except in column G that there is a validation list for choosing the fruits that you want to see.
Formula in column F is an Array Formula, so you need to confirm with Control+Shift+Enter. The other formulae are normal. Just Enter.
I also made a small Table with fruits budget.
Let me know if there is something that you don't understand.
Bookmarks