12+Days+of+Christmas+Activity+Three


 * __Cost Calculation __**

You will need a new formula to calculate expenses. Click on cell P3 and type


 * =SUM(B3*O3) **

which means find the sum of the number in cell B3 multiplied (* means multiply to a computer) by the number in cell O3.

Rather than retype the formula over and over, you can drag cell P3 down to cell P14 to copy the formula all the way down the column.

To find out how much money was spent each day, we need another formula. Click on cell C17 and type


 * =SUM(C3*B3) **

This will find out how much money was spent on Day 1.

Click on cell D17 and type


 * =SUM(D3*B3)+(D4*B4) **

This will find out how much money was spent on Day 2.

Click on cell E17 and type


 * =SUM(E3*B3)+(E4*B4)+(E5*B5) **

This will find out how much money was spent on Day 3.

Follow the pattern to find the amount of money was spent on each day.