Sales Contribution excel formula

[amol bhosale]

How can I show in an Excel formula which articles contribute 80% to the sales of this category?

Which top articles sales contribution is up to 80%. As given in the last column.

Please suggest

[#2]

@amol bhosale 

In E3:

=IF(SUM(D$3:D3)<=80%,1,"")

Fill down.

P.S. The percentages don't correspond to the data...

Also posted at Sales contribution formula 

[#3]

@HansVogelaar 

How to do if data is not sorted and I want to extract city and category level top 80%.

[#4]

@amol bhosale 

Sort the data correctly, otherwise it becomes complicated.