| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running total....
I am adding customers info on an Excelsheet... What I want to do is always
show a running total of Income for the month at the bottom of my sheet no matter how large it gets.... how can I keep the total tab at the bottom even as I add rows, EX: a;alsjkas 300.00 alskjdf;a asl;djkf; a;slfjkd Total 600.00 basically I want to just add the info and the Total tab will automatically adjust below the Rows of information.... Can this be done... please give me instructions, I'm a beginner user... Thx~J |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Running total.... Needing help here!!!
"Jay.... Needing help" wrote: I am adding customers info on an Excelsheet... What I want to do is always show a running total of Income for the month at the bottom of my sheet no matter how large it gets.... how can I keep the total tab at the bottom even as I add rows, EX: a;alsjkas 300.00 alskjdf;a asl;djkf; a;slfjkd Total 600.00 basically I want to just add the info and the Total tab will automatically adjust below the Rows of information.... Can this be done... please give me instructions, I'm a beginner user... Thx~J |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Running total....
Jay,
It's really easy. Just pick the cell in the row you want to have your running total. Put in the Sum Function. =SUM(B1:B8) Here we are summing column B. The next time you insert a row above your total the function will automatically change. If you insert 1 row, then it will be =SUM(B1:B9). Once you enter your new number it will be summed up. Jay.... Needing help wrote: I am adding customers info on an Excelsheet... What I want to do is always show a running total of Income for the month at the bottom of my sheet no matter how large it gets.... how can I keep the total tab at the bottom even as I add rows, EX: a;alsjkas 300.00 alskjdf;a asl;djkf; a;slfjkd Total 600.00 basically I want to just add the info and the Total tab will automatically adjust below the Rows of information.... Can this be done... please give me instructions, I'm a beginner user... Thx~J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| running total by date (not sorted by date though...) | Excel Worksheet Functions | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Running total at bottom of column? | Excel Discussion (Misc queries) | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| how do I keep a running total of my bills? | Charts and Charting in Excel | |||
Linear Mode
