Excel formula.

[Guest]

How do I keep a running total of columns and rows? For example I don't want
to be stuck only with =SUM(A1:A4) which will only add the 4, but keep it
open to infinity if needed. I have a small business and I am trying to make
an accounting ledger of debits and credits.

 

[BenjieLop]

How do I keep a running total of columns and rows? For example I don't
want
to be stuck only with =SUM(A1:A4) which will only add the 4, but keep
it
open to infinity if needed. I have a small business and I am trying to
make
an accounting ledger of debits and credits.

Try this ...

=SUM($A$1:A1)

and copy all the way down until infinity...

Regards.

 

[Guest]

Try this ...

=SUM($A$1:A1)

and copy all the way down until infinity...

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019
View this thread: http://www.excelforum.com/showthread.php?threadid=533164

Thanks BenjieLop, I may have more questions for you.

 

[David Biddulph]

Try this ...

=SUM($A$1:A1)

and copy all the way down until infinity...

Or if you don't want a total at each stage, but merely an overall total, use
=SUM(A:A)