Skip to content

How To Blog

how to

  • How to Create an XML Sitemap for Your Site How-To
  • How to Move Apps to SD Card on Android Phone How-To
  • Convert Video to iPhone or iPad Format Gadgets
  • How to Print Email From Gmail Without Header How-To
  • How to Reduce the Size of WhatsApp on Your iPhone Smartphones
  • Use HP Print and Scan Doctor to Fix Common Printer Problems Tools Review
  • Best gp189 calculator battery 2020

    Best gp189 calculator battery 2020

  • How to Disable Face ID on App Store Purchases? How-To

Sum a Table Column in Word

Posted on October 9, 2020 By blog_786 No Comments on Sum a Table Column in Word

Word lets you calculate the sum of a column in a table, just like in a spreadsheet program such as Excel. In this post, you will learn how to do this in Word 2003, 2007 and 2010/2013/2016. As an example, let’s summarize a column of decimal numbers.

Word 2007 through 2016

Open Word and place your cursor in a blank cell at the bottom of the column that contains the numbers you want to sum.

Sum a Table Column in Word

The Tabular Tools tabs will become available. Click the Layout tab.

Sum a Table Column in Word

Click the Formula button in the Data group.

– /

Sum a Table Column in Word

The correct formula is automatically inserted into the Formula edit box of the Formula dialog box. I selected 0.00 from the Number Format dropdown list to format the number the same as the other numbers in the column. You can choose a different number format depending on your data.

Sum a Table Column in Word

Click “OK” to accept the settings.

Sum a Table Column in Word

The formula field is inserted into the cell, and the amount is calculated and displayed automatically. If you change any of the numbers in the Amount column, right-click the amount and choose Update Field from the pop-up menu to update the total. You can also press F9 when a field is selected to update it.

Sum a Table Column in Word

There is one big caveat when using such formulas in Word. All data must be contiguous, that is, there must be no breaks in the data. For example, take a look at the data below. The second column contains no data for March.

Sum a Table Column in Word

So instead of summing everything from January to June, we only summarize the values ??from April to June. Now if I put 0 in a cell and update the field, it gives me the correct answer that I was looking for.

Sum a Table Column in Word

Obviously, keep this in mind and check the results to make sure they are correct. These types of problems don’t usually occur in Excel because you need to specify exactly which cells you want to perform calculations in, but this is not the case in Word.

You may also notice that you do not see the AutoSum button on the Word Layout tab or on other tabs. This feature is available in Word, but not on any of the ribbon tabs. To access it, you must add it to the Quick Access Toolbar. To do this, click the “Office” button and click the “Word Options” button. In newer versions of Word, click File and then Options.

Sum a Table Column in Word

Select the Customize option from the list on the left side of the Word Options dialog box. In newer versions of Word, you must select the Quick Access Toolbar.

Sum a Table Column in Word

From the Select Commands From drop-down list, select Commands Not On The Ribbon.

Sum a Table Column in Word

Scroll under the Select commands from drop-down list until you find the Sum command. Select it and click the Add button. This adds the Sum command to the command list on the Quick Access Toolbar on the right side of the Word Options dialog box.

Sum a Table Column in Word

Click OK on the Word Options dialog box to close it. The Sum command appears as a button on the Quick Access Toolbar. You can click the Sum button while the cursor is in the last cell in the Sum column of the table discussed earlier to add up the numbers in the column.

Sum a Table Column in Word

Unfortunately, you cannot directly customize the ribbon tabs in Word. Additional tips for customizing and using commands on the ribbon panel are discussed in our post “Customizing the MS Office Ribbon.”

Word 2003

Below is an example of a table that we will use to show you how to sum a column of numbers in a table in Word 2003. To sum the numbers in a Sum column, place your cursor in the last cell of that column.

Sum a Table Column in Word

Choose “Formula” from the “Table” menu.

Sum a Table Column in Word

The formula edit box in the formula dialog box is automatically populated with the corresponding formula. We will format the grand total in the same way as the numbers in the Amount column. Select 0.00 from the Number Format drop-down list.

Sum a Table Column in Word

Click “OK” to accept your settings.

Sum a Table Column in Word

The total amount is entered in the last cell of the “Amount” column.

Sum a Table Column in Word

That’s all! It’s worth noting that you can insert more complex formulas into the formula box if you like, but Word doesn’t support all formulas that Excel supports, so don’t be surprised if you try an Excel formula and get an error. To see a list of all the formulas you can use in Word, browse this list from Microsoft by scrolling down to the available functions section. Enjoy!

–

Office Tips Tags:Word

Post navigation

Previous Post: Hide Confidential Data in a Word 2007/2010 Document
Next Post: Preserve Cell References when Copying a Formula in Excel

Related Posts

  • How to Clear Recently Opened File List in Word Office Tips
  • How to Create and Run Macros in MS Word the Easy Way Office Tips
  • How To Change The Default Font In Office Apps Office Tips
  • Troubleshoot and Fix Office Problems with Repair Office Tips
  • How to Take and Insert Screenshots using OneNote Office Tips
  • Fix End Tag Start Tag Mismatch Error When Opening DOCX Files Office Tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • How-To
  • iOS
  • iPad
  • iPhone
  • Linux Tips
  • macOS
  • MS Office Tips
  • Networking
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • January 2023
  • December 2022
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018

2021 Android ) Apple apps Best browser change Chrome Closing words Concluding remarks Download email Error Facebook From Google Image Internet Keyboard Mac make Movies Music online Packaging phone? Photos Print Search Shortcuts sites Switch Time Tips Tricks turn using Video Videos Watch What With Working? your YouTube

  • How to factory reset your Chromecast 2021 How-To
  • How to Add Stickers, Links, and More to Your Instagram Stories technology
  • Tor vs VPN – Should You Use One or Both? Reviews
  • How To Block Robocalls On Your Mobile Phone How-To
  • Fix Repeating Keys With These Tips How-To
  • 5 Creative Ways to Download Facebook Video How-To
  • 2 Best Sites To Trim & Crop YouTube Videos Google Software/Tips
  • How to Add Shapes in Google Docs 2021 Google Software/Tips

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}
Go to mobile version