Which data specifically represents 20% of total sum

Hey guys,

I feel like this is easier than I'm making it but am having a serious brain lapse right now.

I've attached a very simple example document with two columns (Category & Units). Basically, I'm looking to identify how many categories represent 20%, 30%, 40% of the total sum of units, and what those categories are.

Thanks in advance!

Try

Select both columns ...

Sort by Units (Smallest to Largest)

in C2

=SUM($B$2:B2)/$B$28

Copy down

Format C as %

where B28=TOTAL of All Units

Hey guys,

Thanks for your help and quick replies. For a little more context, let's say I'm looking for both the minimum and maximum number to represent the 20%, 30%, etc...

So more than likely there will be an additional column for each Min & Max.

There are numerous answers as one can pick a number of combinations which be 10%, 20% etc of the total.

The maximum number of categories will based on smallest to largest where as the minimum will be the reverse i.re. largest to smallest.

So sorting smallest to largest, 10 categories make 23% but largest to smallest, 4 categories make 22%: the choice is yours.

What are you seeking to achieve from these calculations?