Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Accumlative values
Posted by Roger Massey on November 16, 2001 5:58 AM
As a novice excel user I was very proud when I managed to add a column. Now I want to add cumulative values. I'm sure that it's very simple, but the paperclip won't tell me!
PLEASE HELP ME
Re: Accumlative values
Posted by Dan on November 16, 2001 6:21 AM
Cumulative values of what? Give us an idea of what you are trying to sum and in what columns/rows.
Re: Accumlative values
Posted by Mark W. on November 16, 2001 6:22 AM
> ...but the paperclip won't tell me!
Oh, there's your problem... You should be using
"The Genius". : )
> ...I want to add cumulative values...
Suppose cells A1:A5 contains {10;20;30;40;50}.
Enter the formula, =SUM($A$1:A1), in cell B1
and copy down to cell. B5.
Re: Accumlative values
Posted by Aladin Akyurek on November 16, 2001 7:55 AM
Roger & Mark: I'm going to put this most enjoable exchange on the wall in my office.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.