running totals

[ramchu2002]

i have 2 columns as below :
values running totals


when we start both the columns are blank.

as i type values in the values column i want the corresponding running totals in tthe other column

what formula should be given for running totals columns.

if a corresponding value column is blanka then the running total should albo be blank.

help

 

[PaddyD]

for data starting in A1, enter:

=IF(ISBLANK(A1),"",SUM($A$1:A1))

in b1 & copy down

seem the simulation below:

Book5
	A	B	C	D
1	1	1
2	2	3
3	3	6
4	4	10
5
6	6	16
7	7	23
8	8	31
9	9	40
10
11
Sheet1

Paddy