Please clarify this better... what cells exactly get what percentages for column A2 through A11
With 35%, 35%, and 30% of 10 cells you have 3 cells for your 30% and 7 cells for 2 x 35% for the 70% remainder in which you have a cell that overlaps the 2 groups for 2 different monetary amounts, which makes no sense.