In B1 enter =A1

In B2 enter = B1+A2

Double-click to fill down.


Gord Dibben MS Excel MVP

On Fri, 2 Mar 2007 09:23:25 -0800, planecents
wrote:

Mike
It works for the one cell in but i would like B to continue to add the
values represented in the next row of A and continue to total the new value
in A
Thanks
Bob @ planecents