Sales Contribution excel formula

Copper Contributor

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

3 Replies

@amol bhosale 

In E3:




Fill down.


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


Also posted at Sales contribution formula 

@Hans Vogelaar 

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

@amol bhosale 

Sort the data correctly, otherwise it becomes complicated.