running total in excel

[grizzly6969]

is there a formula that will keep a running total in excel
example
C2 = 5 + B2 = 5 therfore A2 = 10 -- simple BUT now type in 8 in C2 and
A2 should = 18 -- type 12 in B2 and A2 should = 30 -- type 5 in B2 and
A2 should = 35 and so on and so on

 

[T. Valko]

See this:

http://mcgimpsey.com/excel/accumulator.html

Make sure you read the part about making errors!

 

[Satti Charvak]

Sorry it is not possible in Excel

In Excel ,in a cell, either you can store some data (values) or formula. NOT
both at the same time.

In your case you'll have to maintain values in one column and formulas in
another column.

 

[grizzly6969]

Thank you this helps
--
grizz

See this:

http://mcgimpsey.com/excel/accumulator.html

Make sure you read the part about making errors!

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you this helps