| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I keep up with a monthly amount due from past years?
I need to be able to keep up with a monthly amount that goes back several
years due to someone. |
|
#2
|
|||
|
|||
|
"hotsytotsy79" wrote in message
... I need to be able to keep up with a monthly amount that goes back several years due to someone. Work harder? |
|
#3
|
|||
|
|||
|
Instead of placing Totals at the bottom, place them at the top of the data.
Then sum up the entire column. Like in b2 have =SUM(B3:B50000) That you can keep adding data at the bottom without redoing the total formula. "hotsytotsy79" wrote: I need to be able to keep up with a monthly amount that goes back several years due to someone. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| once you have an amount in a cell how do you get that amount to i. | New Users to Excel | |||
| Restrict input if amount is exceeded | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
| How do I enter a negative dollar amount? | Excel Discussion (Misc queries) | |||
| Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
Linear Mode
