LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
EQ EQ is offline
external usenet poster
 
Posts: 2
Default Adding up #s in Excel

I have a list numbers in a column of cells that I would like to add up.
The only constraint is that I want to output the total sum of numbers
before each cell. Lets say I have 5 in B2, 13 in B3, 1 in B4, and 8 in
B5. I want to get 5 in C2, 18 in C3, 19 in C4, and 27 in C5.

I know I can do this by creating a SUM function for each cell
(C3=SUM(B2:B3) and then C4=SUM(B2:B4) and so forth) but I have more than
50 cells, and it will be a torture by these means.

What should I use to progressively get this sum?



*** Sent via Developersdex http://www.developersdex.com ***
 
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
adding in excel Led_A_Muck[_2_] Excel Discussion (Misc queries) 3 October 30th 08 06:29 PM
Adding with excel Gen Needs Help[_2_] Excel Discussion (Misc queries) 1 November 27th 07 02:59 AM
Adding in Excel cb New Users to Excel 4 October 7th 07 10:31 PM
Adding in Excel Ron Excel Discussion (Misc queries) 5 March 16th 06 12:22 AM
Adding on excel Laura \( '_' \) New Users to Excel 17 January 4th 06 08:29 AM


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