Recently I was asked how many customers made up 25% of my sales. I listed each customer and their sales for a specified period, then sorted descending on sales. The formula in C2 is copied down for as far as the data goes. The secret is in the referencing.
=SUM($B$2:B2)/SUM($B$2:$B$51)
In the denominator, both B2 and [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/08/25/cumulative-percent/
Posted
Aug 25 2009, 04:43 PM
by
Daily Dose of Excel