There are three formulas you need so that the table
can shape your data into something coherent:
?– A formula that gives you the sum of each individual expense for the week
?– A formula that calculates the total amount of money you have spent for each individual day
?– A formula that gives you the total amount of money you have spent over the course of
the entire week
Apple has done a great deal of the work for you by creating preconfigured
functions. To create your first formula, click cell B7, which is where you want
the total of Monday??™s expenditures to appear. Next, click the Function button
in the toolbar and choose Sum.
This automatically creates a formula in cell B7 that adds the data in all
other rows of the B column and displays the results in B7.
CHAPTER 7: I Work, You Work, We All Work with iWork 167
For your second formula, you need to show the total amount that you spent for each item during
the week. Click cell I2 to work with it, and then click the Function toolbar button and choose Sum
again. This formula adds all data for row 2 under each column and displays the total in I2.
Pages:
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236