Google Sheets DropDown Count

[yoyoo95]

It goes about the google sheet file in the link. This is an example of what I'm looking for. In this specific example (see also attached screenshot of the sheet) I want to add the totals of the categories in the drop down list automatically by means of a formula. The idea is that the sheet automatically checks which category it is about and which amount is to the right of it and distinguishes between the categories. Is this possible? So I want the automatically added expenses in F4: F8.

[yoyoo95]

docs.google.com/spreadsheets/d/1CGrIR_oMIICYsA-VesIQ3b2-VoMWkptvMH2OIQNzCB8/edit?usp=sharing

[Flyboy65]

I put a formula in cell F4 and dragged it down. Is this what you wanted?

[yoyoo95]

Yes thanks that was what i was looking for