How to calc percentage
 

I have a list with a column of sales numbers. I want to sum the sales
dollars, then find which customers make up the top 20%, 30%, 40% of
that total dollar amount. What is the easiest way to go about doing
this?

Thank you!


--
excelgurudummy
------------------------------------------------------------------------
excelgurudummy's Profile: http://www.excelforum.com/member.php...o&userid=25441
View this thread: http://www.excelforum.com/showthread...hreadid=395090

Pivot Table sorted on Sales $$$
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"excelgurudummy" wrote:


I have a list with a column of sales numbers. I want to sum the sales
dollars, then find which customers make up the top 20%, 30%, 40% of
that total dollar amount. What is the easiest way to go about doing
this?

Thank you!


--
excelgurudummy
------------------------------------------------------------------------
excelgurudummy's Profile: http://www.excelforum.com/member.php...o&userid=25441
View this thread: http://www.excelforum.com/showthread...hreadid=395090