ADDING A FORMULA TO A TABLE
  • 13 Mar 2023
  • 1 Minute To Read
  • Contributors
  • Dark mode
    Light
  • PDF

ADDING A FORMULA TO A TABLE

  • Dark mode
    Light
  • PDF

Article summary

  1. Start a new document. Click on Table in the menu bar
  2. Click on Insert – then click on Table.
  3. Number of Columns - 6.
  4. Number of Rows - 7. Click OK.
  5. Click on the vertical line between the 5th and 6th row and move it to the left to shorten up the last column.
  6. Click on the vertical line between the 4th and 5th row and move it to the left to shorten up the 5th column.
  7. Shorten the other column columns in the same way. The widest column should be the 1st column.
  8. Type the chart in the table.

Name

#1

#2

#3

#4

Total

Robert Rolf

74

77

84

83

Jane McKigney

88

93

86

90

Jesse Keeward

96

95

93

98

Dawn Palmer

63

78

71

66

Alicia Gomez

83

83

92

87

Cherie Lang

93

94

84

90

Calculate the Totals in Each Row

  1. Click in the first blank cell under Total.
  2. Click on Table in the menu bar, then click on
    Formula. Delete the formula but leave the equals sign.
  3. Click on the down arrow in Paste Function. Select Sum.

  1. Type LEFT between the parentheses.
    (It may be there already).
    Click OK.
  2. If the formula is showing,

right-click here and choose

Toggle Field Codes.

  1. Repeat above steps for each row – calculate the total each Row.

Print the Table


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.