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 you desire. Your spreadsheet should look like the one to right, just before you copy the formulas.

 After you have completed your formula copy it to cells G7 through G19.  You will see some "stuff (zeroes)" 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 did before (Page 5).

 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. Your spreadsheet column G should look something like the image on the right

This would be a great time to Save again.

Absoluting and Multiplication