Excell functions.

J

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

fredg

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.

=Sum(A:A)

but....

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.

Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.
 
J

JohnHamilton

fredg said:
=Sum(A:A)

but....

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.

Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Thanks for pointing it out.
 
Top