How to make a "selection by category" in excel?

Question

excel

I don’t know how to describe it better, I’m doing financial accounting and I need

the file itself https://www.dropbox.com/s/qkow8mknpcfjgns/%D1%83%D... tell me
how to bind a text category to an amount and operate on values, I hope for the screenshot is clear my idea, I don’t even know how to explain :)
ps here something probably needs to be done with the VLOOKUP function, but I don’t know how

Answer 1

see "pivot tables"