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





--
grizz

See this:

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

Make sure you read the part about making errors!

--
Biff
Microsoft Excel MVP


"grizzly6969" wrote in message
...
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





--
grizz

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.
--

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"grizzly6969" wrote:

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





--
grizz

Thank you this helps
--
grizz


"T. Valko" wrote:

See this:

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

Make sure you read the part about making errors!

--
Biff
Microsoft Excel MVP


"grizzly6969" wrote in message
...
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





--
grizz

You're welcome!

--
Biff
Microsoft Excel MVP


"grizzly6969" wrote in message
...
Thank you this helps
--
grizz


"T. Valko" wrote:

See this:

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

Make sure you read the part about making errors!

--
Biff
Microsoft Excel MVP


"grizzly6969" wrote in message
...
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





--
grizz