How to change a range of numbers based on varying percentages?

[mawo]

Hello, everyone,

I have a list of 12 beverages with checkboxes next to them to pick which ones I want to include in the calculation.

In the next column, I have an equal percentage of all selected beverages (if 5 are selected, the formula divides 100% by 5, assigning each of them the value of 20%, as an example.)

Column E lists arbitral percentages based on the beverages' popularity—the percentage of a given beverage people have in relation to others offered.

The problem: how do I make the numbers in column F (expected usage per beverage) reflect the percentage bias from column E? The idea is that those percentages always equal 100% but change proportionally (in contrast to column C, where they check equally).

Here's the link to the quick gif showing it CleanShot 2020-01-11 at 16.34.45.gif

I'd appreciate any help a lot!

 

[J.Ty.]

The following contains the calculation you probably need.

Book1
	A	B	C	D
1		choice 0/1	general popularity	relative popularity among chosen ones
2	Bev1	1	10%	25.00%
3	Bev2		20%	0.00%
4	Bev3	1	30%	75.00%
5	Bev4		40%	0.00%
Sheet3

Cell Formulas
Range	Formula
D2:D5	D2	=IF(B2=1,C2/SUMIF($B$2:$B$5,1,$C$2:$C$5),0)

 

[mawo]

Thank you so much, J.Ty.!! It worked like a charm!