I'm making an expense spreadsheet, to keep track of all my expenses. I have made a dropdown-list with different category (Rent, Food, Others etc.) these are put into C2 to CXX, in the next cell D2 to DXX I put the Expense number.
I would now like to have a summary cells, that tells me how much I have spent in each category (Adding all the expenses from one category together).
How do I go about doing this?