Excel formula.
 

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.

Excel formula.
 

JohnHamilton Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=533164

Excel formula.
 

"BenjieLop" wrote:


JohnHamilton Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=533164

Thanks BenjieLop, I may have more questions for you.

Excel formula.
 

"BenjieLop" wrote
in message ...

JohnHamilton Wrote:
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...

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