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:

 

=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 

@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.