{"id":6238,"date":"2014-06-23T00:01:46","date_gmt":"2014-06-23T07:01:46","guid":{"rendered":"http:\/\/www.wambooli.com\/blog\/?p=6238"},"modified":"2016-06-25T13:23:18","modified_gmt":"2016-06-25T20:23:18","slug":"more-word-table-calculations","status":"publish","type":"post","link":"https:\/\/www.wambooli.com\/blog\/?p=6238","title":{"rendered":"More Word Table Calculations"},"content":{"rendered":"<p>Although it&#8217;s a word processor, Word has Excel-like formulas you can slap down into a table. These formulas assist you with mathematical puzzles that would otherwise be daunting.<br \/>\n<!--more--><br \/>\n<iframe class=\"tscplayer_inline\" name=\"tsc_player\" src=\"\/images\/video\/blog-table-math\/blog-table-math_player.html\" scrolling=\"no\" frameborder=\"0\" webkitallowfullscreen mozallowfullscreen allowfullscreen><\/iframe><\/p>\n<p>The values you put in the parenthesis can be words or cell numbers. The words are:<\/p>\n<p><code>ABOVE<br \/>\nBELOW<br \/>\nRIGHT<br \/>\nLEFT<\/code><\/p>\n<p>These represent the values of all the cells above, below, to the right, or to the left of the current cell.<\/p>\n<p>Cell numbers are similar to Excel: Columns are named letters and rows are named numbers. Figure 1 illustrates the naming scheme.<\/p>\n<div id=\"attachment_6242\" style=\"width: 306px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6242\" src=\"http:\/\/www.wambooli.com\/blog\/wp-content\/uploads\/2014\/06\/table-math.png\" alt=\"Figure 1. Word table cell names.\" width=\"296\" height=\"294\" class=\"size-full wp-image-6242\" srcset=\"https:\/\/www.wambooli.com\/blog\/wp-content\/uploads\/2014\/06\/table-math.png 296w, https:\/\/www.wambooli.com\/blog\/wp-content\/uploads\/2014\/06\/table-math-150x150.png 150w\" sizes=\"auto, (max-width: 296px) 100vw, 296px\" \/><p id=\"caption-attachment-6242\" class=\"wp-caption-text\">Figure 1. Word table cell names.<\/p><\/div>\n<p>So, for example, to add the total of the second and third row from the second column, you&#8217;d use this formula:<\/p>\n<p><code>=SUM(B2,B3)<\/code><\/p>\n<p>Where <code>B<\/code> is the second column and <code>B2<\/code> and <code>B3<\/code> are the cells from the second and third row.<\/p>\n<p>To specify a range of cells, use a colon:<\/p>\n<p><code>=AVERAGE(C2:C14)<\/code><\/p>\n<p>The above formula calculates the average of the contents of cells <code>C2<\/code> through <code>C14<\/code>.<\/p>\n<p>Yes, you can get more advanced than these examples, but at that point you have to question whether you really want a table in Word or to insert an Excel <em>object<\/em> into your document.<\/p>\n<p>I&#8217;ll cover the inserting of Excel objects in another blog post.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Move over, Excel, Word has its own functions.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,22],"tags":[9],"class_list":["post-6238","post","type-post","status-publish","format-standard","hentry","category-main","category-video","tag-word"],"_links":{"self":[{"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/6238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6238"}],"version-history":[{"count":7,"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/6238\/revisions"}],"predecessor-version":[{"id":6246,"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/6238\/revisions\/6246"}],"wp:attachment":[{"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wambooli.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}