Sum cells only to a Maximum value

[Cammandk]

I should know this but just can't get my head around. Any help would be appreciated.
Attached file shows simple layout of whats needed.

 

[Kyrre]

I should know this but just can't get my head around. Any help would be appreciated.
Attached file shows simple layout of whats needed.

Look into this, I am not sure if it was what you where looking for

 

[Cammandk]

Kyrre. Thanks for trying this is not what I need.

I need the investment row to take what ever it can from the Sales Total value upto the max of 500 across the rows.

I'm trying to recover the value up to 500 across the Sales columns

 

[Somendra Misra]

@Cammandk

What rows are you reffering to when you say "across the rows"?

Regards,

 

[Kyrre]

Mas

Kyrre. Thanks for trying this is not what I need.

Make a finish result of how you want it to be, then it is easier to figure out the formulas.

 

[Cammandk]

Revised file with more explainations.
Thanks
D.

 

[Kyrre]

Maybe I have a solution, if I understamds u correctly. Look into it and add comments.

 

[Cammandk]

I've added comments.

 

[Kyrre]

I've added comments.

I dont now what an investment waterfall is. Please answer q in the sheet.

 

[NARAYANK991]

Hi David ,

Is this something like it ?

Narayan

 

[Somendra Misra]

@Cammandk

Now I see what you are looking after. Well, Although Narayan Sir had given you one solution, which I think you will definetly say yes. I had a different solution it is on the same line but I had inserted an extra column.

Please have a look. If this is not what you required than please advise.

Regards,