Hey ROSt52 thanks already for your help. I want to excuse me for my newbie level on this but I hardly ever use it. I have to make it because they are gonna help me (government instances) with giving structure to my finances since I suffer a sort of ADHD.
I hope you can help me changing some things in the current spreadsheet since I already had to do a lot of effort making this one. There already went a whole lot of my spare time in it.
The things I want to do on pages 0912 and 1112 is the next.
Cells A69 to H150 contain monthly expenses. They all have the name of the expender, girlfriend or me. And they have a category. Want I want to do on top. Is making an overview of the cost per category.
Sorry that the spreadsheet is in Dutch by the way. Because we need to see who makes the most expense per category I wanted to split things up. If a certain amount for example is spent by Jessi AND falls under a certain category I want to sum it.
And the chart should give a graphical overview on the information in the ‘table’ on top. Thing is we need to do this each month. So 1212, 0113 and so on (month, year) is the spreadsheet name.
Is there anyway you can help me editing my spreadsheet with the information above or do you need more information. Because I am not familiar with al these functions. Just tried finding it out using the internet but looking at your comment I used wrong functions.
Many many thanks for your help.
P.