Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Cumulative Percent

Daily Dose of Excel

News

  • This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika
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
Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.