| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
