| Entering formulas in the Monthly Totals Column
Move to cell G6 under the title Monthly Totals. Choose
one of the formulas you learned earlier to add each of the
amounts in Parents for the four months. Use any
of the four methods. After you have completed your formula copy
it to the cells G7 to G19. You will see some
"stuff" in cells G10, 11, 12, and 18. This is
because there was "nothing there" to add. So, go in
and clean-up these cells by deleting the zeros in
these cells.
Next, go to G9 and G17 and underline like you've
did before.
Notice that we didn’t copy the percentage
formula when we started this last copying effort. If we had copied a
SUM formula, it would have added the four percentages. We don’t
want the sum of the percentages. We want a percentage
of the Monthly Totals. So, we need to copy this percentage
separately. Now, copy the percentage formula in cell F21
to cell G21. Now put a $ in cells G6 through G19
if you need to, and a % in G21.
|
