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.
In the denominator, both B2 and [...] Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/08/25/cumulative-percent/
Aug 25 2009, 04:43 PM
Daily Dose of Excel