Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
excelgurudummy
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage Calculation clandis Excel Worksheet Functions 5 July 21st 05 07:38 PM
Formatting percentage signs in Excel Romany Excel Discussion (Misc queries) 3 June 1st 05 07:02 PM
Help with function to add percentage to cell based on checkbox. foxgguy2005 Excel Worksheet Functions 3 June 1st 05 05:52 AM
Percentage of overall attendance tannersnonni Excel Discussion (Misc queries) 6 May 13th 05 03:26 PM
display data as a percentage of a subtotal in excel pivot table Fl pivot user Excel Discussion (Misc queries) 2 March 26th 05 12:24 PM


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"