Skip to content

How To Blog

  • 5 Tech Happenings to Look Forward To in 2013 Gadgets
  • 11 Best useful Ways to Fix Gmail Notifications Not Working in Chrome Google Software/Tips
  • How do I completely uninstall games on PS4 Gaming
  • Windows 7 Screensaver and Power Options Not Working? Windows 7
  • Turn Off Admin Approval Mode in Windows 7 Windows 7
  • 5 Best Safe APK Download Sites for Android Apps Tools Review
  • Find Router Default Passwords Computer Tips
  • Can’t Delete Apps on iPhone Due to 3D Touch? iPhone

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

  • Change the Default Margins Used in New Word Documents Office Tips
  • Fix MS Office “Cannot Verify License” Error Message Office Tips
  • How to Clear Recently Opened File List in Word Office Tips
  • How to Customize the Ribbon in MS Word 2010 Office Tips
  • How to Recover Deleted Emails in Office 365 Office Tips
  • Check All Hyperlinks in a MS Word Document in Seconds Office Tips

Leave a Reply Cancel reply

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

Archives

  • June 2023
  • May 2023
  • April 2023
  • 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
  • March 2021
  • 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
  • September 2018
  • August 2018

Categories

  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • Linux
  • Linux Tips
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Wordpress

Recent Posts

  • Unnecessary Windows 10 services that can be safely disabled
  • What Is Taskeng.exe and Is It Safe?
  • What is Facebook Watch and how do I use it in 2020?
  • How to add Google Forms to your site
  • What is a custom domain and how to set it up

Recent Comments

  1. How to Minimize a Windows Program to the System Tray 2023 - How To Blog on How to Fix System Tray or Icons Missing in Windows 10
  2. How can I unlock my Macbook using Apple Watch - How To Blog on How to Install Chrome OS on Macbook or iMac
  3. 4k hdmi switch with optical out - How To Blog on Is A Gaming PC Really More Expensive Than A Console?
  4. online video maker with music and pictures 2023 - How To Blog on 6 Video Editing Tips For Beginners
  5. 5 New Ways to Clean Electronics Safely - How To Blog on How to Clean Your Computer Properly, Inside and Out
  • Outlook Data File Cannot Be Accessed: 4 Fixes To Try Office Tips
  • Add a Linear Regression Trendline to an Excel Scatter Plot MS Office Tips
  • How to Clear the Clipboard in Windows 10 Windows 10
  • 15 Coolest Free Screensavers For Windows 10 Windows 10
  • How to Change the Boot Sequence in the BIOS How-To
  • Enable Display Accommodations On iOS iOS
  • 5 Best Ways to Find Someone’s Email Address Computer Tips
  • Change from Public to Private Network in Windows 7, 8 and 10 Windows

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version