Excel: How to divide each item in sumifs array formula by set value
<p>I have a spreadsheet which looks like this:</p>

<pre><code>A       B           C                 D              E
Status  payed by    involved          # of involved  price
payed   Felix       Felix, Peter            2        22,00 €
open    Timothy     Felix, Peter, Chelsea   3        90,00 €
open    Peter       Peter, Timothy          2        2,40 €
open    Chelsea     Chelsea, Felix          2        7,00 €
</code></pre>

<p>Now, I want a formula which calculates how much each person has to pay to come out equal, while only paying for things in which said person was involved in.
Currently, I do the following:</p>

<pre><code>=SUMIFS(E2:E13; B2:B13; "*Peter*"; A2:A13; "open")
</code></pre>

<p>To calculate how much each person already paid.
Then, I want to calculate how much each person has to pay.
My "dream formula" for that would be:</p>

<pre><code>{=SUMIFS(E2:E13/D2:D13; A2:A13; "open"; C2:C13; "*Peter*")}
</code></pre>

<p>So that each items gets split by the number of people involved and the split part then added to each persons total. The problem is, such an array formula does not exist and is not valid. </p>

<p>How can I correct that? Thank you!!!</p>