software

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.


JohnHamilton Wrote:
gt; How do I keep a running total of columns and rows? For example I don't
gt; want
gt; to be stuck only with =SUM(A1:A4) which will only add the 4, but keep
gt; it
gt; open to infinity if needed. I have a small business and I am trying to
gt; make
gt; 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: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=533164

quot;BenjieLopquot; wrote:

gt;
gt; JohnHamilton Wrote:
gt; gt; How do I keep a running total of columns and rows? For example I don't
gt; gt; want
gt; gt; to be stuck only with =SUM(A1:A4) which will only add the 4, but keep
gt; gt; it
gt; gt; open to infinity if needed. I have a small business and I am trying to
gt; gt; make
gt; gt; an accounting ledger of debits and credits.
gt;
gt; Try this ...
gt;
gt; =SUM($A$1:A1)
gt;
gt; and copy all the way down until infinity...
gt;
gt; Regards.
gt;
gt;
gt; --
gt; BenjieLop
gt;
gt;
gt; ------------------------------------------------------------------------
gt; BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
gt; View this thread: www.excelforum.com/showthread...hreadid=533164
gt;
gt; Thanks BenjieLop, I may have more questions for you.

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

gt; Try this ...
gt;
gt; =SUM($A$1:A1)
gt;
gt; 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