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

I remember watching films on Amazon Prime used to work just fine but it's been a few months since I watched anything and now, for some reason, it doesn't work anymore.

I hear the sound but there's no video - just black.

I tried Firefox, Opera and Librewolf - same Problem, so I wanted to ask here if the problem could be OS-related.

From the research I've done I found that apparently it could be something to do with hdcp copy protection, but I didn't get any error message in that regard.

Does anyone have an idea how this problem can be fixed?