Excel formula.

[JohnHamilton]

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.

[David Biddulph]

"BenjieLop" <[email protected]> wrote
in message news:[email protected]...
>
> 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

[JohnHamilton]

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