Creating a formula that looks at multiple data fields

**Pumba** · 07-28-2010, 07:20 AM

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

**MarvinP** · 07-28-2010, 08:34 AM

See if the attached solves the Bill Sharing question.

**arthurbr** · 07-28-2010, 08:40 AM

Marvin, please refrain from answering a question as long as the OP hasn't complied to the mod's request - Thx

Your answer has been soft deleted and will be reinstated when Op complies

**Pumba** · 07-28-2010, 09:22 AM

Hi Marvin P

Thank you very much for your response. However I can't seem tosee you attachment. I am knew to the site so coul be looking in the wrong place.

Thanks once again for your response. It is very much appreciated.