Since you only have 400 rows, enter this formula in B1:

=Sum($A1:A1)

Click back in B1 and hover the cursor over the little black square in the
lower right corner of the cell.

When the cursor changes from a fat white cross to a skinny black cross,
click and drag down to Row 400.

You don't have to type the formula into each individual cell.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


wrote in message
om...
I have a list of values in collum A and I wantto keep a running talle in
another colulm B is there an easyier way to do this than putting the sum
formular in each cell in collumI B I have 400 of these.
Example
A B
3500 3500
3100 6600