{"id":4314,"date":"2018-08-22T09:29:51","date_gmt":"2018-08-22T09:29:51","guid":{"rendered":"https:\/\/www.isumsoft.com\/it\/?p=4314"},"modified":"2019-11-28T02:06:45","modified_gmt":"2019-11-28T02:06:45","slug":"how-to-sum-up-the-data-in-excel-2016-table","status":"publish","type":"post","link":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/","title":{"rendered":"How to Sum up the Data in Excel 2016 Table"},"content":{"rendered":"<p>In daily work, Excel table is a good helper for statistical data. Sometimes, we need to use an Excel table to make statistic data, such as making the statistics of student performance and company product price list or expense report. Thus, it is going to involve in summing, <a href=\"https:\/\/www.isumsoft.com\/it\/2-ways-to-calculate-the-difference-of-the-data-in-excel-2016\/\">differencing<\/a>, <a href=\"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/\">producting<\/a>, and <a href=\"https:\/\/www.isumsoft.com\/it\/how-to-calculate-quotient-of-the-cells-in-excel-2016\/\">quotienting<\/a> as well as <a href=\"https:\/\/www.isumsoft.com\/it\/4-ways-to-calculate-average-value-of-the-data-in-excel-2016\/\">averaging<\/a> the data in the Excel table. In this article, we mainly introduce <a href=\"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/\">how to sum up the data in Excel 2016<\/a>. Here are four different approaches provided for you.<\/p>\n<ul>\n<li><a href=\"#way1\">Way 1: Using AutoSum to sum up data<\/a><\/li>\n<li><a href=\"#way2\">Way 2: Enter the formula to sum up data<\/a><\/li>\n<li><a href=\"#way3\">Way 3: Insert function to sum up data<\/a><\/li>\n<li><a href=\"#way4\">Way 4: Press keyboards at one blow to sum up data<\/a><\/li>\n<\/ul>\n<h2>4 Ways to sum up the data in Excel 2016 table<\/h2>\n<p>If you store data such as price lists or reimbursement forms in Excel, you may need a quick way to sum up the price or amount. Today, I&#8217;ll show you how to easily sum up data in Excel 2016.<\/p>\n<h3><a id=\"way1\" name=\"way1\"><\/a>Way 1: Using AutoSum to sum up data<\/h3>\n<p>Step 1: Open the Excel table you want to sum up, select the first row of data, and then click the &#8220;<strong>AutoSum<\/strong>&#8221; button to choose <strong>Sum<\/strong> option in the upper right corner of the top toolbar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"450\" class=\"alignnone size-full wp-image-4330\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/choose-autosum-option.png\" alt=\"choose autosum option\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/choose-autosum-option.png 616w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/choose-autosum-option-300x219.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/choose-autosum-option-80x58.png 80w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/p>\n<p>Step 2: We will see that the result of the sum will appear in the cell at the end of the data area we selected. At this point, we <strong>select the cell<\/strong> with the result of the sum and move the mouse to the lower right corner of the cell until the mouse pointer changes to a solid cross shape. Once you see this solid cross shape appears, you pull down until it gets the summation data for all of this column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"551\" height=\"458\" class=\"alignnone size-full wp-image-4322\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/move-the-mouse.png\" alt=\"move the mouse\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/move-the-mouse.png 551w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/move-the-mouse-300x249.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/move-the-mouse-80x66.png 80w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><\/p>\n<h3><a id=\"way2\" name=\"way2\"><\/a>Way 2: Enter the formula to sum up data<\/h3>\n<p>Step 1: Enter the formula: &#8220;<strong>=B2+C2+D2+E2<\/strong>&#8221; in the cell behind the data in the first row. After finishing the input, click any position of the extra edge of the cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"551\" height=\"458\" class=\"alignnone size-full wp-image-4319\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/enter-the-formula.png\" alt=\"enter the formula\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/enter-the-formula.png 551w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/enter-the-formula-300x249.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/enter-the-formula-80x66.png 80w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><\/p>\n<p>Or enter the formula &#8220;<strong>=SUM(B2:E2)<\/strong>&#8221; in the F2 cell and press &#8220;<strong>Enter<\/strong>&#8221; to display the sum.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"450\" class=\"alignnone size-full wp-image-4424\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/press-enter.png\" alt=\"press enter\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/press-enter.png 531w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/press-enter-300x254.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/press-enter-80x68.png 80w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/p>\n<p>Step 2: Then we can use the previous method to drag the sign of the cross shape, and then all the data of the sum will be displayed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"518\" height=\"458\" class=\"alignnone size-full wp-image-4320\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/get-the-summation-data.png\" alt=\"get the summation data\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/get-the-summation-data.png 518w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/get-the-summation-data-300x265.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/get-the-summation-data-80x71.png 80w\" sizes=\"auto, (max-width: 518px) 100vw, 518px\" \/><\/p>\n<h3><a id=\"way3\" name=\"way3\"><\/a>Way 3: Insert function to sum up data<\/h3>\n<p>Step 1: Select the cell behind the data in the first row, and then select the <strong>Formulas<\/strong> &gt; <strong>Insert Function<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"533\" height=\"454\" class=\"alignnone size-full wp-image-4321\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/insert-function.png\" alt=\"insert function\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/insert-function.png 533w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/insert-function-300x256.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/insert-function-80x68.png 80w\" sizes=\"auto, (max-width: 533px) 100vw, 533px\" \/><\/p>\n<p>Step 2: In the <strong>Insert Function<\/strong> window. Select the <strong>SUM<\/strong> function and click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"433\" height=\"375\" class=\"alignnone size-full wp-image-4323\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-sum-function.png\" alt=\"select Sum function\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-sum-function.png 433w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-sum-function-300x260.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-sum-function-80x69.png 80w\" sizes=\"auto, (max-width: 433px) 100vw, 433px\" \/><\/p>\n<p>Step 3: Type <strong>B2:E2<\/strong> directly in the <strong>Number1<\/strong> edit box, and then hit <strong>OK<\/strong>. At last, use the previous method to drag the sign of the cross shape, and then all the data of the sum will be displayed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"344\" class=\"alignnone size-full wp-image-4325\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-b2e2-directly.png\" alt=\"type b2e2 directly\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-b2e2-directly.png 594w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-b2e2-directly-300x174.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-b2e2-directly-80x46.png 80w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/p>\n<p>Alternatively, you can also choose to click the button with red arrows behind the edit box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"345\" class=\"alignnone size-full wp-image-4444\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-red-arrow-1.png\" alt=\"click red arrow\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-red-arrow-1.png 594w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-red-arrow-1-300x174.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-red-arrow-1-80x46.png 80w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/p>\n<p>This <strong>Function Arguments<\/strong> window will appear, select the region to sum over, and then <strong>B2:E2<\/strong> will be displayed in the window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"454\" class=\"alignnone size-full wp-image-4324\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region.png\" alt=\"select the region\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region.png 608w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region-300x224.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region-200x150.png 200w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region-80x60.png 80w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/p>\n<p>Next, you&#8217;ll see <strong>B2:E2<\/strong> in the <strong>Number1<\/strong> edit box (see the following figure), and finally click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"344\" class=\"alignnone size-full wp-image-4316\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/b2e2-displayed.png\" alt=\"b2e2 displayed\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/b2e2-displayed.png 594w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/b2e2-displayed-300x174.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/b2e2-displayed-80x46.png 80w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/p>\n<h3><a id=\"way4\" name=\"way4\"><\/a>Way 4: Press keyboards at one blow to sum up data<\/h3>\n<p>Step 1: Select all the data, as shown in the figure.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"515\" height=\"450\" class=\"alignnone size-full wp-image-4336\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-all-the-data.png\" alt=\"select all the data\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-all-the-data.png 515w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-all-the-data-300x262.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-all-the-data-80x70.png 80w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/p>\n<p>Step 2: Press &#8220;<strong>Alt and + =<\/strong>&#8221; keyboards simultaneously, and the data is all summed up.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"515\" height=\"450\" class=\"alignnone size-full wp-image-4337\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/the-data-is-all-summed-up.png\" alt=\"the data is all summed up\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/the-data-is-all-summed-up.png 515w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/the-data-is-all-summed-up-300x262.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/the-data-is-all-summed-up-80x70.png 80w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/p>\n<p>The above are 4 ways of summing up the data in the Excel 2016 table. It&#8217;s a very simple operation. Have you learned them? Hopefully, this article will be of help to you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In daily work, Excel table is a good helper for statistical data. Sometimes, we need to use an Excel table to make statistic data, such as making the statistics of student performance and company product price list or&#8230; <\/p>\n","protected":false},"author":2,"featured_media":4327,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[220],"class_list":["post-4314","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","tag-make-the-data-of-summation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Sum up the Data in Excel 2016 Table<\/title>\n<meta name=\"description\" content=\"In this article, we mainly introduce how to sum up the data in Excel 2016. Here are four different approaches provided for you.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Sum up the Data in Excel 2016 Table\" \/>\n<meta property=\"og:description\" content=\"In this article, we mainly introduce how to sum up the data in Excel 2016. Here are four different approaches provided for you.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/\" \/>\n<meta property=\"og:site_name\" content=\"iSumsoft\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/isumsofthome\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-22T09:29:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-28T02:06:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/sum-up-the-data.png\" \/>\n\t<meta property=\"og:image:width\" content=\"515\" \/>\n\t<meta property=\"og:image:height\" content=\"451\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Darren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:site\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Darren\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/\"},\"author\":{\"name\":\"Darren\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\"},\"headline\":\"How to Sum up the Data in Excel 2016 Table\",\"datePublished\":\"2018-08-22T09:29:51+00:00\",\"dateModified\":\"2019-11-28T02:06:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/\"},\"wordCount\":581,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/sum-up-the-data.png\",\"keywords\":[\"make the data of summation\"],\"articleSection\":[\"Office\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/\",\"name\":\"How to Sum up the Data in Excel 2016 Table\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/sum-up-the-data.png\",\"datePublished\":\"2018-08-22T09:29:51+00:00\",\"dateModified\":\"2019-11-28T02:06:45+00:00\",\"description\":\"In this article, we mainly introduce how to sum up the data in Excel 2016. Here are four different approaches provided for you.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/sum-up-the-data.png\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/sum-up-the-data.png\",\"width\":515,\"height\":451,\"caption\":\"sum up the data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-sum-up-the-data-in-excel-2016-table\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Sum up the Data in Excel 2016 Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"name\":\"iSumsoft\",\"description\":\"Tell You More about IT World\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\",\"name\":\"iSumsoft Studio\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"width\":16,\"height\":16,\"caption\":\"iSumsoft Studio\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/isumsofthome\\\/\",\"https:\\\/\\\/x.com\\\/iSumsoft\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL9RaYqRcQ0f0buIzXiaNDw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\",\"name\":\"Darren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"caption\":\"Darren\"},\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/author\\\/darren-king\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Sum up the Data in Excel 2016 Table","description":"In this article, we mainly introduce how to sum up the data in Excel 2016. Here are four different approaches provided for you.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/","og_locale":"en_US","og_type":"article","og_title":"How to Sum up the Data in Excel 2016 Table","og_description":"In this article, we mainly introduce how to sum up the data in Excel 2016. Here are four different approaches provided for you.","og_url":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/","og_site_name":"iSumsoft","article_publisher":"https:\/\/www.facebook.com\/isumsofthome\/","article_published_time":"2018-08-22T09:29:51+00:00","article_modified_time":"2019-11-28T02:06:45+00:00","og_image":[{"width":515,"height":451,"url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/sum-up-the-data.png","type":"image\/png"}],"author":"Darren","twitter_card":"summary_large_image","twitter_creator":"@iSumsoft","twitter_site":"@iSumsoft","twitter_misc":{"Written by":"Darren","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/#article","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/"},"author":{"name":"Darren","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798"},"headline":"How to Sum up the Data in Excel 2016 Table","datePublished":"2018-08-22T09:29:51+00:00","dateModified":"2019-11-28T02:06:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/"},"wordCount":581,"commentCount":0,"publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/sum-up-the-data.png","keywords":["make the data of summation"],"articleSection":["Office"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/","url":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/","name":"How to Sum up the Data in Excel 2016 Table","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/#primaryimage"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/sum-up-the-data.png","datePublished":"2018-08-22T09:29:51+00:00","dateModified":"2019-11-28T02:06:45+00:00","description":"In this article, we mainly introduce how to sum up the data in Excel 2016. Here are four different approaches provided for you.","breadcrumb":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/#primaryimage","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/sum-up-the-data.png","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/sum-up-the-data.png","width":515,"height":451,"caption":"sum up the data"},{"@type":"BreadcrumbList","@id":"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.isumsoft.com\/it\/"},{"@type":"ListItem","position":2,"name":"How to Sum up the Data in Excel 2016 Table"}]},{"@type":"WebSite","@id":"https:\/\/www.isumsoft.com\/it\/#website","url":"https:\/\/www.isumsoft.com\/it\/","name":"iSumsoft","description":"Tell You More about IT World","publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.isumsoft.com\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.isumsoft.com\/it\/#organization","name":"iSumsoft Studio","url":"https:\/\/www.isumsoft.com\/it\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","width":16,"height":16,"caption":"iSumsoft Studio"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/isumsofthome\/","https:\/\/x.com\/iSumsoft","https:\/\/www.youtube.com\/channel\/UCL9RaYqRcQ0f0buIzXiaNDw"]},{"@type":"Person","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798","name":"Darren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","caption":"Darren"},"url":"https:\/\/www.isumsoft.com\/it\/author\/darren-king\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/4314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/comments?post=4314"}],"version-history":[{"count":0,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/4314\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media\/4327"}],"wp:attachment":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media?parent=4314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/categories?post=4314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/tags?post=4314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}