LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Sum a column in groups

Hey I was wondering if there was a way to have a column summed up in a certain total. Like i have a 100 numbers in a column I can get the column split summed into 5 different groups of 20. I would also it need it to skip blank cells. and sum the first 20 values as they appeared in the column.

Thanks in advance
 
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
COUNTING GROUPS IN ONE COLUMN SANDY Excel Discussion (Misc queries) 2 November 4th 09 03:54 PM
Breakout groups from one column of data Maarkr Excel Discussion (Misc queries) 2 October 8th 09 01:34 PM
Ranking different groups in one column Marie Bayes Excel Discussion (Misc queries) 13 August 6th 09 06:55 AM
Analysing different groups of data in the same column bananaman Excel Discussion (Misc queries) 1 November 12th 08 10:48 AM
summing groups in a column [email protected] Excel Programming 2 June 15th 07 08:46 PM


All times are GMT +1. The time now is 08:21 AM.

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"