=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
Forum Discussion
Sales Contribution excel formula
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
How to do if data is not sorted and I want to extract city and category level top 80%.
