{"id":4446,"date":"2018-08-29T08:08:11","date_gmt":"2018-08-29T08:08:11","guid":{"rendered":"https:\/\/www.isumsoft.com\/it\/?p=4446"},"modified":"2019-11-28T01:17:29","modified_gmt":"2019-11-28T01:17:29","slug":"2-methods-to-perform-product-calculation-on-the-data-in-excel-2016","status":"publish","type":"post","link":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/","title":{"rendered":"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016"},"content":{"rendered":"<p>When you learn to make tables that are no longer limited to <a href=\"https:\/\/www.isumsoft.com\/it\/how-to-sum-up-the-data-in-excel-2016-table\/\">summing<\/a>, <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\/how-to-calculate-quotient-of-the-cells-in-excel-2016\/\">quotienting<\/a> and <a href=\"https:\/\/www.isumsoft.com\/it\/4-ways-to-calculate-average-value-of-various-data-in-excel-2016\/\">averaging<\/a>, you can start to focus on how to multiply two or more cells. Cross product is something that you often use in mathematics. We can calculate the number of small points by heart, but the number is large, or plenty of number needs to be calculated, which is a little bit difficult at this point, so I think it is useful to choose to <a href=\"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/\">automatically compute the product in Excel<\/a>, which can not only quick and accurate but also convenient.<\/p>\n<p>So I&#8217;m going to share with you a little bit about how to do this in Excel. Whether you used to use Excel or not, I&#8217;m sure you&#8217;ll be able to take the product yourself after reading this tutorial.<\/p>\n<h2>2 methods to perform PRODUCT calculation on the data in Excel 2016<\/h2>\n<ul>\n<li><a href=\"#mtd1\">Method 1: Type the formula to perform PRODUCT calculation<\/a><\/li>\n<li><a href=\"#mtd2\">Method 2: Insert function to perform PRODUCT calculation<\/a><\/li>\n<\/ul>\n<h3><a id=\"mtd1\" name=\"mtd1\"><\/a>Method 1: Type the formula to perform PRODUCT calculation<\/h3>\n<p>Step 1: Open the target Excel, type the formula &#8220;<strong>=C2*D2*E2<\/strong>&#8221; in the F2 cell and press <strong>Enter<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"415\" height=\"530\" class=\"alignnone size-full wp-image-4453\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-the-formula.png\" alt=\"type the formula\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-the-formula.png 415w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-the-formula-235x300.png 235w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-the-formula-80x102.png 80w\" sizes=\"auto, (max-width: 415px) 100vw, 415px\" \/><\/p>\n<p>Or enter the formula &#8220;<strong>=PRODUCT(C2:D2:E2)<\/strong>&#8221; in the F2 cell and press <strong>Enter<\/strong> to display the product.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"530\" class=\"alignnone size-full wp-image-4447\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/press-enter-1.png\" alt=\"press enter\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/press-enter-1.png 478w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/press-enter-1-271x300.png 271w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/press-enter-1-80x89.png 80w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/p>\n<p>Step 2: As you can see, the product of C2:E2 displays in the F2 cell. Then move the cursor to the lower right corner of the F2 cell, press the left button of the mouse and drag it down when it is a solid black cross &#8220;<strong>+<\/strong>&#8220;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"530\" class=\"alignnone size-full wp-image-4458\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/drag-it-down.png\" alt=\"drag it down\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/drag-it-down.png 419w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/drag-it-down-237x300.png 237w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/drag-it-down-80x101.png 80w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/p>\n<p>Step 3: When you let go of the mouse, you will find that all the calculations of the automatic cross-product are done, as shown in the figure below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"530\" class=\"alignnone size-full wp-image-4448\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/product-are-done.png\" alt=\"product are done\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/product-are-done.png 419w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/product-are-done-237x300.png 237w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/product-are-done-80x101.png 80w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/p>\n<h3><a id=\"mtd2\" name=\"mtd2\"><\/a>Method 2: Insert function to perform PRODUCT calculation<\/h3>\n<p>Step 1: Select the F2 cell, switch to the <strong>Formulas<\/strong> and click the <strong>Insert Function<\/strong> in the library group.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"386\" height=\"529\" class=\"alignnone wp-image-4455 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-insert-function.png\" alt=\"click Insert Function\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-insert-function.png 386w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-insert-function-219x300.png 219w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-insert-function-80x110.png 80w\" sizes=\"auto, (max-width: 386px) 100vw, 386px\" \/><\/p>\n<p>Step 2: The &#8220;<strong>Insert Function<\/strong>&#8221; dialog box pops up, select <strong>Math&amp;Trig<\/strong> function in the category, then select <strong>PRODUCT<\/strong> function in the text box below, and click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"433\" height=\"375\" class=\"alignnone wp-image-4450 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-product-function.png\" alt=\"select PRODUCT function\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-product-function.png 433w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-product-function-300x260.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-product-function-80x69.png 80w\" sizes=\"auto, (max-width: 433px) 100vw, 433px\" \/><\/p>\n<p>Step 3: The &#8220;<strong>Function Arguments<\/strong>&#8221; window will pop up, type <strong>C2:E2<\/strong> in Number1, and click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"344\" class=\"alignnone size-full wp-image-4452\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-c2-e2.png\" alt=\"type C2:E2\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-c2-e2.png 570w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-c2-e2-300x181.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/type-c2-e2-80x48.png 80w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>Alternatively, you can also choose to click the button with <strong>a red arrow<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"344\" class=\"alignnone size-full wp-image-4457\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-red-arrow-2.png\" alt=\"click red arrow\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-red-arrow-2.png 570w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-red-arrow-2-300x181.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-red-arrow-2-80x48.png 80w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>This <strong>Function Arguments<\/strong> window will appear, select the region of <strong>C2:E2<\/strong>, and then C2:E2 will be displayed in the box. Click the <strong>red arrow<\/strong> button again.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"439\" height=\"529\" class=\"alignnone size-full wp-image-4451\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region-of-c2-e2.png\" alt=\"select the region of C2:E2\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region-of-c2-e2.png 439w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region-of-c2-e2-249x300.png 249w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/select-the-region-of-c2-e2-80x96.png 80w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/p>\n<p>Next, you&#8217;ll see <strong>C2:E2<\/strong> in the Number1 box, and click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"344\" class=\"alignnone size-full wp-image-4456\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-ok-1.png\" alt=\"click OK\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-ok-1.png 570w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-ok-1-300x181.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/click-ok-1-80x48.png 80w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>Step 4: At this time, the product of C2:E2 appears in F2 cell, and then move the cursor to the lower right corner of the F2 cell and drag down a solid black cross until all the automated cross-product calculations are displayed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"532\" class=\"alignnone size-full wp-image-4449\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/product-calculations-are-displayed.png\" alt=\"product calculations are displayed\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/product-calculations-are-displayed.png 419w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/product-calculations-are-displayed-236x300.png 236w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/product-calculations-are-displayed-80x102.png 80w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you learn to make tables that are no longer limited to summing, differencing, quotienting and averaging, you can start to focus on how to multiply two or more cells. Cross product is something that you often use&#8230; <\/p>\n","protected":false},"author":2,"featured_media":4454,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[230,231],"class_list":["post-4446","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","tag-compute-the-product","tag-multiply-cells"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016<\/title>\n<meta name=\"description\" content=\"If you\u2019re reading this post, you can learn how to perform PRODUCT calculation on the data in Excel 2016, this will be very helpful when you need it.\" \/>\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\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016\" \/>\n<meta property=\"og:description\" content=\"If you\u2019re reading this post, you can learn how to perform PRODUCT calculation on the data in Excel 2016, this will be very helpful when you need it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/\" \/>\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-29T08:08:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-28T01:17:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/calculate-product.png\" \/>\n\t<meta property=\"og:image:width\" content=\"417\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/\"},\"author\":{\"name\":\"Darren\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\"},\"headline\":\"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016\",\"datePublished\":\"2018-08-29T08:08:11+00:00\",\"dateModified\":\"2019-11-28T01:17:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/\"},\"wordCount\":457,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/calculate-product.png\",\"keywords\":[\"compute the product\",\"multiply cells\"],\"articleSection\":[\"Office\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/\",\"name\":\"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/calculate-product.png\",\"datePublished\":\"2018-08-29T08:08:11+00:00\",\"dateModified\":\"2019-11-28T01:17:29+00:00\",\"description\":\"If you\u2019re reading this post, you can learn how to perform PRODUCT calculation on the data in Excel 2016, this will be very helpful when you need it.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/calculate-product.png\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/calculate-product.png\",\"width\":417,\"height\":530,\"caption\":\"calculate product\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016\"}]},{\"@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":"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016","description":"If you\u2019re reading this post, you can learn how to perform PRODUCT calculation on the data in Excel 2016, this will be very helpful when you need it.","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\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/","og_locale":"en_US","og_type":"article","og_title":"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016","og_description":"If you\u2019re reading this post, you can learn how to perform PRODUCT calculation on the data in Excel 2016, this will be very helpful when you need it.","og_url":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/","og_site_name":"iSumsoft","article_publisher":"https:\/\/www.facebook.com\/isumsofthome\/","article_published_time":"2018-08-29T08:08:11+00:00","article_modified_time":"2019-11-28T01:17:29+00:00","og_image":[{"width":417,"height":530,"url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/calculate-product.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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/#article","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/"},"author":{"name":"Darren","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798"},"headline":"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016","datePublished":"2018-08-29T08:08:11+00:00","dateModified":"2019-11-28T01:17:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/"},"wordCount":457,"commentCount":0,"publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/calculate-product.png","keywords":["compute the product","multiply cells"],"articleSection":["Office"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/","url":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/","name":"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/calculate-product.png","datePublished":"2018-08-29T08:08:11+00:00","dateModified":"2019-11-28T01:17:29+00:00","description":"If you\u2019re reading this post, you can learn how to perform PRODUCT calculation on the data in Excel 2016, this will be very helpful when you need it.","breadcrumb":{"@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/#primaryimage","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/calculate-product.png","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/calculate-product.png","width":417,"height":530,"caption":"calculate product"},{"@type":"BreadcrumbList","@id":"https:\/\/www.isumsoft.com\/it\/2-methods-to-perform-product-calculation-on-the-data-in-excel-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.isumsoft.com\/it\/"},{"@type":"ListItem","position":2,"name":"2 Methods to Perform PRODUCT Calculation on the Data in Excel 2016"}]},{"@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\/4446","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=4446"}],"version-history":[{"count":0,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/4446\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media\/4454"}],"wp:attachment":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media?parent=4446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/categories?post=4446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/tags?post=4446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}