calculate when previous lookup value changes

Please bear with me as I try to explain what I am looking for. I am trying to calculate something called crush 1 complete fill is when there are a quantity of 10 "ZS", 9 "ZL", and 11 "ZM". I am trying to create a template so when an order is complete, I will be able to copy and paste a summary into the sheet and it will be able to calculate the crush formula every time the price of "ZS" changes (only focus on "Real Price" the trading platform uses shortcuts so I made a formula to fix this). The hard part is that it is dynamic data. And it isn't always as pretty as completing 1 crush at 10,9,11 quantity. So I need the formula to also calculate the average of ZS,ZL,ZM prices since previous calculation and when the running total of ZS quantity hits another multiple of 10 to calculate crush. In this example crush will be calculated at I9, I12, I17, I20, and I23. Let me know if you need clarification as i expect it. Thank you in advance! <b>Excel 2012</b> <table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"> <colgroup> <col width="25px" style="background-color: #DAE7F5" /> <col /> <col /> <col /> <col /> <col /> <col /> <col /> <col /> <col /> </colgroup> <thead> <tr style=" background-color: #DAE7F5;text-align: center;color: #161120"> <th></th> <th>A</th> <th>B</th> <th>C</th> <th>D</th> <th>E</th> <th>F</th> <th>G</th> <th>H</th> <th>I</th> </tr> </thead> <tbody> <tr > <td style="color: #161120;text-align: center;">8</td> <td style="font-weight: bold;text-align: center;;">Order ID</td> <td style="font-weight: bold;text-align: center;;">Contract</td> <td style="font-weight: bold;text-align: center;;">Price</td> <td style="font-weight: bold;text-align: center;;">BuySell</td> <td style="font-weight: bold;text-align: center;;">OrderType</td> <td style="font-weight: bold;text-align: center;;">Quantity</td> <td style="font-weight: bold;text-align: center;;">OakTimeInForce</td> <td style="font-weight: bold;text-align: center;;">Real Price</td> <td style="font-weight: bold;;">Crush @ fill</td> </tr> <tr > <td style="color: #161120;text-align: center;">9</td> <td style="text-align: right;;">25496771</td> <td style=";">ZS</td> <td style="text-align: right;;">10652</td> <td style=";">Buy</td> <td style=";">LMT</td> <td style="text-align: right;;">10</td> <td style=";">GTC</td> <td style="text-align: right;;">10652.5</td> <td style="text-align: right;;">122.8</td> </tr> <tr > <td style="color: #161120;text-align: center;">10</td> <td style="text-align: right;;">25496771</td> <td style=";">ZL</td> <td style="text-align: right;;">3124</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">9</td> <td style=";">GTC</td> <td style="text-align: right;;">3124</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">11</td> <td style="text-align: right;;">25496771</td> <td style=";">ZM</td> <td style="text-align: right;;">3838</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">11</td> <td style=";">GTC</td> <td style="text-align: right;;">3838</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">12</td> <td style="text-align: right;;">25496771</td> <td style=";">ZS</td> <td style="text-align: right;;">10680</td> <td style=";">Buy</td> <td style=";">LMT</td> <td style="text-align: right;;">10</td> <td style=";">GTC</td> <td style="text-align: right;;">10680</td> <td style=";">Calculate</td> </tr> <tr > <td style="color: #161120;text-align: center;">13</td> <td style="text-align: right;;">25496771</td> <td style=";">ZL</td> <td style="text-align: right;;">3124</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">9</td> <td style=";">GTC</td> <td style="text-align: right;;">3124</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">14</td> <td style="text-align: right;;">25496771</td> <td style=";">ZM</td> <td style="text-align: right;;">3838</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">11</td> <td style=";">GTC</td> <td style="text-align: right;;">3838</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">15</td> <td style="text-align: right;;">25496771</td> <td style=";">ZS</td> <td style="text-align: right;;">10676</td> <td style=";">Buy</td> <td style=";">LMT</td> <td style="text-align: right;;">1</td> <td style=";">GTC</td> <td style="text-align: right;;">10677.5</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">16</td> <td style="text-align: right;;">25496771</td> <td style=";">ZS</td> <td style="text-align: right;;">10680</td> <td style=";">Buy</td> <td style=";">LMT</td> <td style="text-align: right;;">7</td> <td style=";">GTC</td> <td style="text-align: right;;">10680</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">17</td> <td style="text-align: right;;">25496771</td> <td style=";">ZS</td> <td style="text-align: right;;">10682</td> <td style=";">Buy</td> <td style=";">LMT</td> <td style="text-align: right;;">2</td> <td style=";">GTC</td> <td style="text-align: right;;">10682.5</td> <td style=";">Calculate</td> </tr> <tr > <td style="color: #161120;text-align: center;">18</td> <td style="text-align: right;;">25496771</td> <td style=";">ZL</td> <td style="text-align: right;;">3124</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">9</td> <td style=";">GTC</td> <td style="text-align: right;;">3124</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">19</td> <td style="text-align: right;;">25496771</td> <td style=";">ZM</td> <td style="text-align: right;;">3838</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">11</td> <td style=";">GTC</td> <td style="text-align: right;;">3838</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">20</td> <td style="text-align: right;;">25496771</td> <td style=";">ZS</td> <td style="text-align: right;;">10692</td> <td style=";">Buy</td> <td style=";">LMT</td> <td style="text-align: right;;">10</td> <td style=";">GTC</td> <td style="text-align: right;;">10692.5</td> <td style=";">Calculate</td> </tr> <tr > <td style="color: #161120;text-align: center;">21</td> <td style="text-align: right;;">25496771</td> <td style=";">ZL</td> <td style="text-align: right;;">3115</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">9</td> <td style=";">GTC</td> <td style="text-align: right;;">3115</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">22</td> <td style="text-align: right;;">25496771</td> <td style=";">ZM</td> <td style="text-align: right;;">3830</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">11</td> <td style=";">GTC</td> <td style="text-align: right;;">3830</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">23</td> <td style="text-align: right;;">25496771</td> <td style=";">ZS</td> <td style="text-align: right;;">10694</td> <td style=";">Buy</td> <td style=";">LMT</td> <td style="text-align: right;;">10</td> <td style=";">GTC</td> <td style="text-align: right;;">10695</td> <td style=";">Calculate</td> </tr> <tr > <td style="color: #161120;text-align: center;">24</td> <td style="text-align: right;;">25496771</td> <td style=";">ZL</td> <td style="text-align: right;;">3115</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">9</td> <td style=";">GTC</td> <td style="text-align: right;;">3115</td> <td style="text-align: right;;"></td> </tr> <tr > <td style="color: #161120;text-align: center;">25</td> <td style="text-align: right;;">25496771</td> <td style=";">ZM</td> <td style="text-align: right;;">3830</td> <td style=";">Sell</td> <td style=";">LMT</td> <td style="text-align: right;;">11</td> <td style=";">GTC</td> <td style="text-align: right;;">3830</td> <td style="text-align: right;;"></td> </tr> </tbody> </table> <p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p> <br /><br /> <table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" > <tr> <td style="padding:6px" > <b>Worksheet Formulas</b> <table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"> <thead> <tr style=" background-color: #DAE7F5;color: #161120"> <th width="10px">Cell</th> <th style="text-align:left;padding-left:5px;">Formula</th> </tr> </thead> <tbody> <tr> <th width="10px" style=" background-color: #DAE7F5;color: #161120">H9</th> <td style="text-align:left">=IF(<font color="Blue">B9=$C$1,C9,IF(<font color="Red">B9=$B$1,C9,IF(<font color="Green">B9=$D$1,IF(<font color="Purple">RIGHT(<font color="Teal">C9,1</font>)+0=4,C9+1,IF(<font color="Teal">RIGHT(<font color="#FF00FF">C9,1</font>)+0=6,C9+1.5,IF(<font color="#FF00FF">RIGHT(<font color="Navy">C9,1</font>)+0=2,C9+0.5,IF(<font color="Navy">RIGHT(<font color="Blue">C9,1</font>)+0=0,C9</font>)</font>)</font>)</font>)</font>)</font>)</font>)</td> </tr> <tr> <th width="10px" style=" background-color: #DAE7F5;color: #161120">I9</th> <td style="text-align:left">=(<font color="Blue">(<font color="Red">C10*0.11</font>)+(<font color="Red">C11*0.22</font>)-C9*0.1</font>)</td> </tr> </tbody> </table> </td> </tr> </table> <br />