LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 683
Default Sum sections of data

I have a multiple groups of data with line breaks between each. I would like
to sum the column and in the output cell, have the SUM equation. I want this
because I may change one of the value and would want it to update
automatically.

7
5
6
6
9
33 (<-output cell)

5
6
2
1
1
0
1
16 (<-output cell)

 
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
Averaging Sections of data ATC123 Excel Worksheet Functions 1 September 22nd 10 05:57 PM
SUMIF with sections of data Brian Excel Programming 8 August 2nd 09 08:26 PM
Copy Paste sections of data Nikki Excel Worksheet Functions 12 December 10th 08 07:42 PM
Worksheet Sections RJ Excel Discussion (Misc queries) 0 June 7th 07 05:28 PM
Delte blank rows between different sections of data Steven R. Berke Excel Programming 2 July 27th 03 01:06 AM


All times are GMT +1. The time now is 12:33 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"