Creating a formula that looks at multiple data fields

[Pumba]

-------------------------------------------------------------------------------

Hi I am wanting to insert a formula (into the orange boxes on the 'Split' tab that looks at the table (E4:H13). This table split out who in my flat owes who for which bills.

I want a formula to drive the re-imbursement table so that it returns the value of what each flat mate needs to reimburse the other.

For example:

- Amanda needs to reimburse Ollie. I want a formula in C16 that:
1. returns all of the amounts in Column E where Ollie was the payer (this will represent the money Amanda owes Ollie)

2. The formula then needs to be extended to the other orange boxes.

I have attached a copy of the worksheet below.

Many thanks