Under the last expense, label Column “A" as “Total Expenses." Just under Total Expenses, label Column “A" as “Balance Avail." This is the amount that will be carried up to the top of the next week’s column.
In the row titled “Spendable," type in the equation to add the Balance Fwd and the Deposit rows: “@sum(b2..b5)." Your equation may be a bit different — the last number, which is the cell number, should be the row and column of the last deposit line.
Test the worksheet by plugging in 1000 for the balance forward on the first week, then 2000 for one of the deposits and 1000 for the each additional deposit. The worksheet should add up the balance forward and deposits and insert the total in the row labeled “Spendable."
In the row titled “Total Expense," insert the equation “@sum(b6..b19)." If your expenses fall into a different box, be sure to use that box instead of b19. Fill in some expenses and make sure the spreadsheet properly inserts the total in the “Total Expense" box for the week.
Insert the equation “@sum(b5-b20)" in the “Balance Avail" row. If your expenses are totaled on row 45, the equation would be “b5-b45," instead of “b5-b20." The worksheet should subtract your expenses for that week from the spendable. If your spendable was 3000 and your expenses were 1000, the worksheet should show 2000 in the “Balance Avail" row.
Scroll up to the top of the column for the next week. Insert the equation “@sum(b21) into the “Balance Fwd" row. If your Balance Avail is on row 43, you would enter 43 instead of 21 in the equation. The spreadsheet should insert the number in the “Balance Avail" column into the “Balance Fwd" column for the next week.
Most spreadsheets will convert the format of the formula (equation), but if your spreadsheet does not, reviews your software's help section on formatting formulas.