I wish to be able to store running totals in my Spread
sheet.

If I have values in A1:A10 for example, how would I add
the values to B1:B10 respectively.

Once they are added up, the Values from the formulas in
A1:A10 will be cleared by my Macro.

Basically, all I want is a formula to add A1:A10+B1:B10
then hold the values in B1:B10.

After the sheet has been filled in again, I would like to
repeat the process, keeping the B column as a running
total.
Pete

Pete

In B1 enter =IF(A1<"",A1,"")

In B2 enter =IF(A2<"",B1 + A2,"")

Drag/copy B2 down to B10


Gord Dibben Excel MVP

\On Tue, 22 Mar 2005 12:41:58 -0800, "Pete"
wrote:

I wish to be able to store running totals in my Spread
sheet.

If I have values in A1:A10 for example, how would I add
the values to B1:B10 respectively.

Once they are added up, the Values from the formulas in
A1:A10 will be cleared by my Macro.

Basically, all I want is a formula to add A1:A10+B1:B10
then hold the values in B1:B10.

After the sheet has been filled in again, I would like to
repeat the process, keeping the B column as a running
total.
Pete

Just another way:

=SUM($A$1:A1)

And copy down as needed.
--

HTH,

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Pete

In B1 enter =IF(A1<"",A1,"")

In B2 enter =IF(A2<"",B1 + A2,"")

Drag/copy B2 down to B10


Gord Dibben Excel MVP

\On Tue, 22 Mar 2005 12:41:58 -0800, "Pete"
wrote:

I wish to be able to store running totals in my Spread
sheet.

If I have values in A1:A10 for example, how would I add
the values to B1:B10 respectively.

Once they are added up, the Values from the formulas in
A1:A10 will be cleared by my Macro.

Basically, all I want is a formula to add A1:A10+B1:B10
then hold the values in B1:B10.

After the sheet has been filled in again, I would like to
repeat the process, keeping the B column as a running
total.
Pete