web analytics

Referring to Cell Range and Explaining the Most Important Functions in Мicrosoft Word 2013

Microsoft Word 2013

When you need to calculate the values in particular table, you can refer to singular cell, set of cells or range of cells. The Word referring cell system uses the A1 Convention where the letters refer to the cell’s column and the numbers refer to the cell’s row. In every particular Word table, the top left cell is referred as A1. You can use this rule for orientation when referring to other cells in the table. There are various Word functions that can use the referring system to address the cells, such as: SUM(), AVERAGE(), PRODUCT(), etc.

Every cell from the table in MS Word 2013 has its own reference by which you can call the cells in the formula.

01 - table

The cell in the upper left is referred as A1, and the other cells in the same row are referred as B1, C1, D1 and E1 depending on the order by which they appear in the row, from left to right. If the cell has reference letter that is distanced from the letter A according to the alphabetical order, then the cell is more distanced from the first cell in the row. The numbers are reference for rows and the letters are reference for columns.

The cell A4 is in the same column with cell A1, but is three rows below. It is the same kind of referring as the one in the MS Excel. The advantage of this kind of referring compared with the referring with the positional arguments is that you can refer to one, two or more cells that do not need to be adjacent to the formula cell or to each other, so you do not have to refer the entire row or column.

02 - two referred cells

If you add the formula “=SUM(A1,E4)” to the cell C3 you will get the result of 9000 because 5000 + 4000 = 9000. The references in the formulas are divided with comma.

03 - range referring

Referring by cell range is when you refer the range from one cell to another covering all the columns and rows between them. So, if you want to make the cell E5 sum of every cell with number value in the table, you have to insert the formula “=SUM(A1:E4)”, thus the result will be 93000. It is important that you enter the “:” sign between the referred cells. You can refer the range between cells in the same row or column.

Referring to the cell range is applicable for every function in the Paste function drop down list. Some of the most usable functions are:

  • AVERAGE() – Calculates the average of referred cells inside the parentheses.
  • COUNT() – Calculates the count of the referred cells inside the parentheses.
  • MAX() – Returns the maximum value of the referred cells inside the parentheses.
  • MIN() – Returns the minimum value of the referred cells inside the parentheses.
  • PRODUCT() – Multiplies the values of the referred cells inside the parentheses.
  • SUM() – Calculates the sum of the referred cells inside the parentheses.

Leave a Reply