LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default percentages of counts

I have several thousand records of traveling to work times in minutes. I
want percentages of the total amount of times. For example: there are 5
occurances of 30 minutes, 7 occurances of 20 minutes, 11 occurances of 15
minutes....etc. So for the total 23 occurances, approximately 50% of trips
take 15 min, 34% of trips take 20 minutes and 21% of trips take 30 min....etc.

I have subtotaled the number of times, how do I get the percentages of those
totals of the grand total.

I am new to Excel and am not finding the manual very helpful.
--
SP
 
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
Multiple Tab Counts KB Excel Discussion (Misc queries) 10 May 25th 07 04:55 PM
Column Counts Brurobiney Excel Discussion (Misc queries) 1 March 15th 07 09:07 PM
counts of dates jjuan New Users to Excel 4 February 1st 07 01:33 PM
getting several hundred n-counts johnny vino Excel Discussion (Misc queries) 2 September 12th 06 05:36 PM
floating counts Bob in Granger Excel Discussion (Misc queries) 2 July 28th 05 06:30 PM


All times are GMT +1. The time now is 01:40 AM.

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

About Us

"It's about Microsoft Excel"