Allocate a total to 10 people based on shares

Hi,

I am looking to get a formula to split the amount in b12 evenly between 6 people on full share and split it between 4 others on 50% shares. Total of all splits should equate to the amount in b12 cell. For other events split will be different.

Could someone help with this?

Thanks,
Jtom2024

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Formula Help" doesn't tell us anything about your question. I have updated it for you this time because you are a new member. --6StringJazzer

You don't say who will get 100% and who will get 50%.

This solution is hard-coded for exactly what you asked for. If you are going to vary the 6/4 distribution then you will need a more comprehensive solution.

EDIT: Removed attachment, see subsequent post with more general solution.

Please update your profile to show the actual Excel version (2016, 365, etc.). The number "16" does not tell us what functionality you have available.

I noticed you did say that the split may change. Here is a more general solution using functions available in MS 365. Note that results have been rounded to two decimal points so you are going to have rounding errors for some values.

=ROUND($B12*MAKEARRAY(1,SUM($C12:$D12),LAMBDA(r,c,IF(c<=$C12,$C$11,$D$11)))/SUMPRODUCT($C$11:$D$11,$C12:$D12),2)

Hi admin,

can you please clarify what r and c in your formula? for my understanding

=ROUND($B12*MAKEARRAY(1,SUM($C12:$D12),LAMBDA(r,c,IF(c<=$C12,$C$11,$D$11)))/SUMPRODUCT($C$11:$D$11,$C12:$D12),2)

can you please clarify what r and c in your formula? for my understanding

Parameters for rows and columns in the array.