Entering the column formulas
The formulas for the columns will total each category in the table.
To enter the column formulas
- In cell B8, type the formula =Sum(B3..B7) to total the goals for the team.
- In cell C8, type the formula =Sum(C3..C7) to total the assists for the team.
- In cell D8, type the formula =B8+C8 to total the points for the team.
- Select cells A1 to D2, and click the Bold button
on the property bar.
- Select cells B8 to D8, and click the Bold button
on the property bar.
Continue