how to enter simple list and sum

[John]

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

 

[Gord Dibben]

John

In B1 enter =A1

In B2 enter =B1+A2

Copy down to B5


Gord Dibben MS Excel MVP