I want to write a formula where I can add values to a cell whether another cell states approves the "transaction".
It will be easier to explain with an example. Consider a spreadsheet containing the costs of a flat share.
Purchase Adam Joe Peter To x $5 $5 $0 Peter y $0 $7 $7 Adam
Given the table above, I would like to create another table showing how much money do people owe each other:
Owe to Adam Joe Peter Adam $0 $0 $5 Joe $7 $0 $5 Peter $7 $0 $0
I am not sure how to create the second table. Any ideas how? I was thinking of something along the lines of a loop, and if statements.