Your lobster fishing business is straightforward, and you run your accounting in Excel. You maintain separate workbooks for each
year, and each workbook has a spreadsheet for every month. The monthly spreadsheets are identical except for their names, which are January, February, etc. You have found that you need to sum your diesel fuel expenditures, which are always recorded in cell D18, for the months of August through December. What three-dimensional formula would give you that result
The three-dimensional formula that would give you the required result, that is suming the diesel fuel expenditures, which are always recorded in cell D18 for the months of August through December is:
=SUM(August:December!D18).
Explanation:
First, enter the excel starting formula "=SUM(". Type "August" or left-click on the August sheet with the mouse. Type in colon and December or hold the Shift key and left-click on the December sheet. Then, select the cell C3 in the December sheet. Before pressing "Enter," add a closing bracket. The sum formula looks exactly like this: "=SUM(August:December!D18)." This formula can completely be typed manually. The formula sums up cell D18 across each of the sheets from August to December, returning a value.
As you pay on a mortage mothly, it pays down the balance. This money works for you and becomes a form of investment. Rent simply goes toward paying your cost of ling and doesn't get invested.
