We can also use a formula to total the values vertically in the columns to find the number of items Sam hopes to sell each month, and the overall total for the first four months.
| 
|
| © Microsoft Corporation
|
The formula for cell B6 is copied across to total all the columns:
| 
|
| © Microsoft Corporation
|
Finally we can
see that Sam predicts a total sales value of 190 by the
end of the first four months. We could change the data in the
table and the formulas would automatically recalculate the
results in the affected cells.
|
