Sliding Scale Calculation Help (total for x columns)

[ryan640]

Hello,

Is there a way to have a formula get the total for x columns?

For example the first row for Company 2 would be the total of ($10*100%) + ($10 *100%) +(10%*50%) vs company 3 which would be the total of ($20*100%) + ($20*50%). The tricky part is that company 2 on the next row could have 4 months. So the same thing would need to happen (12*100%)+(12*100)+(12*100)+(12*25)

	Price	Number of Months	Month 1	Month 2	Month 3	Month 4
Company 2	$10	3	100%	100%	50%	25%
Company 3	$20	2	100%	50%	50%
Company 2	$12	4	100%	100%	100%	25%

 

[ryan640]

For those that come across this in the future. Here is the answer.
=SUM('starting cell:OFFSET(starting cell,0,'number of columns-1))

Excel Sum X amount of columns depending on a value in another cell

Is there a way that you can use sum() in excel and that sums up x amount of columns depending on number given in another cell. See below for example Example of how it's today In this picture I have

stackoverflow.com