Hello,

I need some help creating size breakdowns for sizes s,m,l,xl,xxl. I would like to put in a value such as 100 items total and excel spit out the amounts of s,m,l,xl,xxl corresponding with percentages to the specific sizes. For example, 100 items i want it to show s 10, m 30, l 40, xl 18 and xxl 2. and so on if i have 65 total quantities it excel would give me the exact amount of s,m,l,xl,xxl.

Thank you in advance! Also, i would rather not use a pivot table for this specific situation.


Thanks!