Didn't really work, I think my description wasn't clear enough. So lets try again:
Its a sheet with following columns:
A B C D E
Date Description Amount Category Balance.
In each single row I want to be able to put a single entry of expense, ie buying petrol on the station would look something like this:
03/09 Petrol -9£ Petrol 90£
Now in every cell in the row D there is a drop down list with some categories (food/petrol/etc)
Now in Column G I would like to have a list of all the categories:
and then in an empty cell next to each category in the column F, a formula that will find every occurrence of lets say petrol in column D, pair it with the amount in the following cell from column C until 'the end' of sheet add it up and come up with the amount of how much I spent on petrol.
hopes that helps and someone would be able to solve my problem.