I have a ledger in which I record expenses made by multiple persons (let's call them A, B, C and D).
The structure is - roughly - the following:
COLUMN 1 COLUMN2 COLUMN3 COLUMN4 Date Amount Person Description
I would like to track the expenses of each one of these persons. To do that, I have added a fifth column in which there are 4 cells, one for each person.
Ideally, the formula of each one of these cells should be:
For all the cells ranging from C1 to C100, check the content of the cell. If the content matches the name of the person, then add the amount of the B cell of the same row to this cell.
I am, however, unsure on how to do this and would appreciate suggestions :)