Skip to main content

Perform Basic Calculations in MS Word Table


Perform Basic Calculations in Word Table


The general idea about MS Word is that, it's all about typing. Most of the users think that it's nothing but a word processor. Of course they are not wrong. But you can perform some basic calculations in MS Word while you're working with a table. It allows you to perform logical comparisons too!


Intermediate level users should already know this trick. But the basic users may not have any knowledge about MS Word Table Function. That's why I'm sharing this little trick. 


Applies to:
  • Word XP/ 2003
  • Word 2007
  • Word 2010/ 2013

Note: This tutorial is prepared based on MS Word 2010. So you may notice slight changes in other versions.




How to Perform Calculations?

To perform basic calculations in MS Word, you have to create a table. After creating the table, input numbers there. Have a look at the illustration below:


Product
January
February
March
Total
A
12
12
15

B
8
9
10

C
23
22
25
Total


Suppose you've to sum up the values of rows and columns of this table. And for this work, you don't need to use Excel. Simply use the Formula option. 

In Word XP/ 2003, you will find the Formula option under Table menu. 

And in the ribbon interface of Word 2007/ 2010/ 2013, the Formula option will be in on the Layout tab, in the Data group as shown in the image below - 


MS Word Formula Option in Layout Tab


Note: The Layout tab will be available when you put your mouse in a table. When you're out of the table, this tab will be hidden.

Now place the cursor on Product A Total cell. Open the Formula option. And you will get the following window - 

MS Word Formula Window


Since there is no value in the top, Formula automatically assumed the values on the left side. If you put the cursor in the January total cell, it will show =SUM(ABOVE)Simply hit OK to sum up the values. 

But if there are values both on left and top, then it will consider the values of the top. In that case, if you need to sum up the left side values, you have to manually write the formula as =SUM(LEFT)



How to Update the Formula Result?

Suppose you've already performed a calculation. Now if you change some values, the result will not be automatically updated as MS Excel. Now you can follow two ways - 

  • Method 1: Simply delete the result and use the formula again. 
  • Method 2: Select the result by mouse, and press F9

If there are multiple formulae on the table and you need to update all the results, Press Ctrl+A > the F9


In earlier version of MS Word, there were some limitations. But Word 2010 or 2013 is more flexible. You can use the formulae in different ways. While using the formula, you can use all the 4 directions of a cell - Left, Right, Above and Below!

And you can use the following functions:
  • Average =Average(ABOVE)
  • Count =Count(ABOVE) 
  • Max =MAX(LEFT)
  • Min =MIN(BELOW)
  • Product  =PRODUCT(ABOVE) 
  • Sum =SUM(ABOVE) 
Caution: The function will not work without Equal (=) sign. And it must be typed on the Formula window. 



Hope this will help you a lot. If you need any help, just knock me . . . 



Stay with Marks PC Solution to get more interesting IT topics!





Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing. Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing.  Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout.  Click to enlarge the image Download the PDF file from the button below. Follow...

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...