<div>
I am confused. <br><br>In the Summary Desired, row for Customer ID refers to rows for both customers in the upper table. Why?
</div>


<div>
The summary was just my way of trying to get it to work correctly so I could then compute each customers cost share<br><br>
</div>


<div>
<div class="content wysiwyg-content fr-view">
This seems very complicated to me and I am concerned I might just be overthinking it. &nbsp;I have my results for this simple example in rows j:o<br><a href="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569150/Book2.xlsx" rel="ugc">Book2.xlsx</a><br>But I really need to come up with a way to get these results as I add more Customers at various footage marks on the line.<br>-cost per foot of line is 5.95<br>-first 300 feet is free<br>-as customers come on to line the footage responsible gets shared with all up to that point &nbsp;then shifts to the next level of customers responsible and that level is shared and so forth until there is just a remaining length shared solely by the last person on the line (you will see column g &amp; h adjust as I add more customers to this line) this is the key getting a summary that really adjusts with these numbers as more customers are added to this sheet.<br><br>I am open to tweaking the set of the sheet whatever you think might help me make this work.
</div>
</div>


Book2.xlsx


This seems very complicated to me and I am concerned I might just be overthinking it.  I have my results for this simple example in rows j:o
Book2.xlsx
But I really need to come up with a way to get these results as I add more Customers at various footage marks on the line.
-cost per foot of line is 5.95
-first 300 feet is free
-as customers come on to line the footage responsible gets shared with all up to that point  then shifts to the next level of customers responsible and that level is shared and so forth until there is just a remaining length shared solely by the last person on the line (you will see column g & h adjust as I add more customers to this line) this is the key getting a summary that really adjusts with these numbers as more customers are added to this sheet.
I am open to tweaking the set of the sheet whatever you think might help me make this work.


I am confused.
In the Summary Desired, row for Customer ID refers to rows for both customers in the upper table. Why?


The summary was just my way of trying to get it to work correctly so I could then compute each customers cost share

Line share calculation


This seems very complicated to me and I am concerned I might just be overthinking it.  I have my results for this simple example in rows j:o
Book2.xlsx
But I really need to come up with a way to get these results as I add more Customers at various footage marks on the line.
-cost per foot of line is 5.95
-first 300 feet is free
-as customers come on to line the footage responsible gets shared with all up to that point  then shifts to the next level of customers responsible and that level is shared and so forth until there is just a remaining length shared solely by the last person on the line (you will see column g &amp; h adjust as I add more customers to this line) this is the key getting a summary that really adjusts with these numbers as more customers are added to this sheet.
I am open to tweaking the set of the sheet whatever you think might help me make this work.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.