CorelTUTOR Home Tile Help
Restart Back Forward

Entering the column formulas

The formulas for the columns will total each category in the table.

To enter the column formulas

  1. In cell B8, type the formula =Sum(B3..B7) to total the goals for the team.
  2. In cell C8, type the formula =Sum(C3..C7) to total the assists for the team.
  3. In cell D8, type the formula =B8+C8 to total the points for the team.
  4. Select cells A1 to D2, and click the Bold button Bold button on the property bar.
  5. Select cells B8 to D8, and click the Bold button Bold button on the property bar.

Continue