Hello! I'm a general spreadsheet newbie, I don't have a lot of experience with either Excel or LibreOffice Calc but I'd like to start tracking my monthly spending and wanted to ask if someone could tell me how to do this:

I'm entering every expense with the date and amount and a specific category i.e. groceries, car, fun stuff, etc. (so there are three columns). So far I've just typed in the name of the category but I'd like to create a drop-down menu that allows me to select a category (i.e. "groceries").

In addition to that, I would like to make a "current total" cell for each category, where all the expenses of a certain category (i.e. every expense labelled "groceries") are added and that shows the sum of all those expenses.

Any help is much appreciated <3