excel formula
 

sorry looks simple but iam confused

date change
I 1.09.09 70 (70)
II 2.09.09 35.5 (35.5+70)
III 3.09.09 -285 (-285+35.5+70) any body help in creating a
formula in adding values adjcent colum upwards

excel formula
 

Try the below in cell D1 and copy down as required
=SUM(C$1:C1)

and something more about referencing. Below are the different reference
styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

If this post helps click Yes
---------------
Jacob Skaria


"shaanu" wrote:

sorry looks simple but iam confused

date change
I 1.09.09 70 (70)
II 2.09.09 35.5 (35.5+70)
III 3.09.09 -285 (-285+35.5+70) any body help in creating a
formula in adding values adjcent colum upwards

excel formula
 

Hi,

This assumes your first row of data is row 2 and c1 is empty. Put this in c2
and drag down

=C1+B2

Mike

"shaanu" wrote:

sorry looks simple but iam confused

date change
I 1.09.09 70 (70)
II 2.09.09 35.5 (35.5+70)
III 3.09.09 -285 (-285+35.5+70) any body help in creating a
formula in adding values adjcent colum upwards

excel formula
 

Hi,
not sure what you mean but assuming your numbers are in column B starting
row 1 in cell C1 enter
=B1
Then in C2 you will enter and copy this formula down

=B2+C1

if this helps please click yes thanks

"shaanu" wrote:

sorry looks simple but iam confused

date change
I 1.09.09 70 (70)
II 2.09.09 35.5 (35.5+70)
III 3.09.09 -285 (-285+35.5+70) any body help in creating a
formula in adding values adjcent colum upwards