how to enter simple list and sum
 

using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?

if the list would look like this
0.58
-1.22
1.79
-0.56
-0.92

the output would look something like
0.58 0.58
-1.22 -0.64
1.79 1.15
-0.56 0.59
-0.92 -0.33

how to enter simple list and sum
 

John

In B1 enter =A1

In B2 enter =B1+A2

Copy down to B5


Gord Dibben MS Excel MVP

On Wed, 16 May 2007 06:34:13 +0300, "John" wrote:

using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?

if the list would look like this
0.58
-1.22
1.79
-0.56
-0.92

the output would look something like
0.58 0.58
-1.22 -0.64
1.79 1.15
-0.56 0.59
-0.92 -0.33