{"id":60572,"date":"2026-04-08T11:13:41","date_gmt":"2026-04-08T06:13:41","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=60572"},"modified":"2026-04-08T20:05:40","modified_gmt":"2026-04-08T15:05:40","slug":"how-to-use-sumproduct-in-excel","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel","title":{"rendered":"How to Use SUMPRODUCT in Excel: Formula &#038; Insights"},"content":{"rendered":"<p>Few Excel formulas pack as much analytical power into a single expression as SUMPRODUCT. Knowing how to use SUMPRODUCT in Excel lets you multiply paired values across ranges, evaluate multiple conditions, and return a combined total in one step, all without building out extra helper columns or nesting several functions together.<\/p>\n<div><\/div>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-main.webp\" alt=\"How to Use Sumproduct in Excel\" width=\"650\" \/><\/div>\n<p>This guide walks through the syntax, real-world examples, and proven techniques that make this formula valuable across financial analysis, performance tracking, and reporting workflows.<\/p>\n<p>Whether you work with small datasets or large structured tables, the steps covered here will help you apply this formula with confidence and get accurate results every time.<\/p>\n<h2>What is the SUMPRODUCT Function in Excel?<\/h2>\n<p><strong>Definition:<\/strong> To understand how to use SUMPRODUCT in Excel, start with what it does: this formula takes two or more arrays, multiplies the values at each corresponding position, and returns the sum of all those products.<\/p>\n<p>Rather than treating a range as a single block, it processes every row or column pair individually, making it well-suited for totaling paired data such as unit quantities and prices.<\/p>\n<p>Professionals applying how to use SUMPRODUCT in Excel rely on it for weighted averages, conditional totals, and multi-criteria performance summaries. Unlike SUM or COUNT, it can assess several conditions at once within a single expression.<\/p>\n<p>A frequent source of errors is supplying arrays of unequal length, so always confirm that every range covers the same number of cells before running the formula.<\/p>\n<h2>Why Use SUMPRODUCT in Excel for Advanced Calculations?<\/h2>\n<p>Knowing how to use SUMPRODUCT in Excel removes the need to build long nested expressions for routine analytical tasks. It keeps formulas compact and spreadsheets easier to manage.<\/p>\n<p>Here is why analysts and professionals rely on it:<\/p>\n<ul>\n<li><strong>Perform multiple calculations at once:<\/strong> Handles array multiplication and summation within one formula, cutting out intermediate steps.<\/li>\n<li><strong>Calculate weighted averages:<\/strong> Applies each value\u2019s assigned weight directly inside the expression for proportional precision.<\/li>\n<li><strong>Combine logical conditions:<\/strong> Evaluates several criteria in one formula without layering multiple IF statements.<\/li>\n<li><strong>Simplify complex formulas:<\/strong> Condenses tasks that would otherwise require several SUM, IF, or COUNT functions into a single line.<\/li>\n<li><strong>Avoid helper columns:<\/strong> Eliminates the need for extra calculation columns, keeping the worksheet clean.<\/li>\n<li><strong>Improve calculation efficiency:<\/strong> Processes array operations in a single pass, particularly useful in large structured datasets.<\/li>\n<li><strong>Useful in financial and data analysis:<\/strong> Pairs effectively with other <a href=\"https:\/\/chartexpo.com\/blog\/excel-functions-for-data-analysis\" target=\"_blank\" rel=\"noopener\">Excel functions for data analysis<\/a> to surface deeper business insights.<\/li>\n<\/ul>\n<h2>Key Uses of the SUMPRODUCT function in Excel<\/h2>\n<p>Seeing where this formula fits in practice makes it far easier to apply correctly. Knowing how to use SUMPRODUCT in Excel opens up tasks ranging from basic array math to conditional reporting across multiple criteria.<\/p>\n<p>Common applications include:<\/p>\n<ul>\n<li><strong>Multiply arrays and sum results:<\/strong> Takes paired values from two or more ranges and returns their combined total in a single step.<\/li>\n<li><strong>Conditional calculations:<\/strong> Filters and totals values that satisfy multiple criteria, all within one formula.<\/li>\n<li><strong>Weighted averages:<\/strong> Assigns proportional importance to each value, making it a reliable choice when calculating a <a href=\"https:\/\/chartexpo.com\/blog\/weighted-average-on-excel\" target=\"_blank\" rel=\"noopener\">weighted average in Excel<\/a>.<\/li>\n<li><strong>Count with multiple criteria:<\/strong> Tallies records meeting several simultaneous conditions without requiring additional formulas.<\/li>\n<li><strong>Data validation and checks:<\/strong> Compares two datasets side by side to surface mismatches or inconsistencies at a glance.<\/li>\n<li><strong>Generate dynamic reports:<\/strong> Produces self-updating summaries that integrate naturally with <a href=\"https:\/\/chartexpo.com\/blog\/custom-sorting-in-excel\" target=\"_blank\" rel=\"noopener\">custom sorting in Excel<\/a>.<\/li>\n<\/ul>\n<h2>Syntax of the SUMPRODUCT Function in Excel<\/h2>\n<p>Grasping the syntax is the first step toward applying this formula reliably across any dataset. Knowing how to use SUMPRODUCT in Excel across different scenarios becomes simpler once you understand its underlying structure, especially when working with organized data prepared through <a href=\"https:\/\/chartexpo.com\/blog\/how-to-use-excel-power-query\" target=\"_blank\" rel=\"noopener\">how to use Excel Power Query<\/a>.<\/p>\n<h3>Formula:<\/h3>\n<p>=SUMPRODUCT(array1, [array2], [array3], &#8230;)<\/p>\n<p>The first array argument is required; all additional arrays are optional. The formula multiplies the values at each matching position across all supplied arrays and then adds those products.<\/p>\n<p>Every array must share identical dimensions, meaning the same number of rows and columns. When dimensions differ, the formula returns an error. You can also embed logical expressions inside the arrays to perform conditional calculations without a separate column.<\/p>\n<h2>How to use SUMPRODUCT in Excel?<\/h2>\n<p>Working through concrete examples is the clearest way to understand how to use SUMPRODUCT in Excel across different analytical scenarios.<\/p>\n<h3>Example 1: Simple Multiplication and Sum<\/h3>\n<p>Consider a retail store that tracks weekly product sales:<\/p>\n<ul>\n<li><strong>\u00a0Step 1: Enter Units Sold in B2:B6<\/strong><\/li>\n<\/ul>\n<p>Input the number of units sold for each product.<\/p>\n<ul>\n<li><strong>\u00a0Step 2: Enter Unit Prices in C2:C6<\/strong><\/li>\n<\/ul>\n<p>Add the selling price per unit for each product.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-1.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<ul>\n<li><strong>Step 3: Apply the formula<\/strong><\/li>\n<\/ul>\n<p>Type = SUMPRODUCT (B2:B6, C2:C6) to multiply units by prices and sum the totals automatically.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-2.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<h3>Example 2: Weighted Average Calculation<\/h3>\n<p>Consider a company that evaluates employee performance using weighted KPIs:<\/p>\n<ul>\n<li><strong>Step 1: Enter Scores in B2:B6<\/strong><\/li>\n<\/ul>\n<p>Add each employee\u2019s performance rating.<\/p>\n<ul>\n<li><strong>Step 2: Enter Weights in C2:C6<\/strong><\/li>\n<\/ul>\n<p>Convert percentages into decimals (0.30, 0.25, etc.).<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-3.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<ul>\n<li><strong>Step 3: Apply the weighted formula<\/strong><\/li>\n<\/ul>\n<p>Use = SUMPRODUCT (B2:B6, C2:C6) \/ SUM(C2:C6) to multiply scores by weights and divide by total weight.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-4.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<h2>Top 5 Practical Use Cases of SUMPRODUCT in Excel<\/h2>\n<ul>\n<li><strong>Business Unit Performance Distribution Analysis <\/strong><\/li>\n<\/ul>\n<p>In the Business Unit Performance Distribution Analysis, Retail delivers the strongest metric balance, while Corporate Sales and E-commerce account for the largest shares of revenue contribution.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-5.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<ul>\n<li><strong>Cash Inflows and Outflows by Department<\/strong><\/li>\n<\/ul>\n<p>The Cash Inflows and Outflows by Department chart maps cash movement across activities and payment channels, making each department\u2019s proportional allocation and contribution visible at a glance.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-6.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<ul>\n<li><strong>Budget Utilization by Performance Status and Cost Type<\/strong><\/li>\n<\/ul>\n<p>The Budget Utilization by Performance Status and Cost Type view reveals how budget amounts are distributed proportionally across performance levels and cost categories, capturing both the weighted and conditional dimensions of financial resource planning.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-7.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<ul>\n<li><strong>Monthly Business Performance Overview<\/strong><\/li>\n<\/ul>\n<p>The Monthly Business Performance Overview tracks revenue growth, profit margin, operating expenses, and customer retention to give a complete picture of business health over time.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-8.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<ul>\n<li><strong>Quarterly Budget Changes and Cost Reduction Analysis<\/strong><\/li>\n<\/ul>\n<p>The Quarterly Budget Changes and Cost Reduction Analysis charts how periodic gains and losses stack up to shape overall financial outcomes across each quarter.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-9.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<h2 data-section-id=\"d54ikf\" data-start=\"0\" data-end=\"50\">How to Analyze SUMPRODUCT Results in Excel?<\/h2>\n<p data-start=\"52\" data-end=\"260\">Analyzing SUMPRODUCT results in Excel helps you evaluate weighted data, compare multiple variables, and uncover deeper insights from complex datasets. Follow these steps to effectively interpret your results:<\/p>\n<h3 data-section-id=\"ixg8wf\" data-start=\"262\" data-end=\"306\">Step 1: Understand Your Data Structure<\/h3>\n<p data-start=\"307\" data-end=\"538\">Start by reviewing the data used in the SUMPRODUCT formula. Ensure your arrays or ranges are aligned correctly, as SUMPRODUCT multiplies corresponding values and then sums them. A clear structure is essential for accurate analysis.<\/p>\n<h3 data-section-id=\"50aenz\" data-start=\"540\" data-end=\"582\">Step 2: Apply the SUMPRODUCT Formula<\/h3>\n<p data-start=\"583\" data-end=\"797\">Use the SUMPRODUCT function to calculate weighted totals or combined results across multiple ranges. This is especially useful for analyzing <a href=\"https:\/\/chartexpo.com\/blog\/performance-metrics\" target=\"_blank\" rel=\"noopener\">performance metrics<\/a>, costs, or contributions across different categories.<\/p>\n<h3 data-section-id=\"1rm9myb\" data-start=\"799\" data-end=\"835\">Step 3: Break Down the Results<\/h3>\n<p data-start=\"836\" data-end=\"1060\">Instead of looking at a single total, analyze how each variable contributes to the final result. Separate your data into categories such as departments, products, or regions to better understand the impact of each component.<\/p>\n<h3 data-section-id=\"120ylq5\" data-start=\"1062\" data-end=\"1095\">Step 4: Compare Key Metrics<\/h3>\n<p data-start=\"1096\" data-end=\"1279\">Use additional formulas or pivot tables to compare SUMPRODUCT results across different segments. This helps identify which categories perform better and where improvements are needed.<\/p>\n<h3 data-section-id=\"1fniuja\" data-start=\"1281\" data-end=\"1316\">Step 5: Create Visualizations<\/h3>\n<p data-start=\"1317\" data-end=\"1535\">Convert your results into charts like comparison bars or stacked visuals to make insights easier to interpret. For more advanced and interactive charts, you can use <strong data-start=\"1482\" data-end=\"1495\">ChartExpo<\/strong> to simplify complex data visualization.<\/p>\n<h3 data-section-id=\"js6qdn\" data-start=\"1537\" data-end=\"1580\">Step 6: Interpret Trends and Insights<\/h3>\n<p data-start=\"1581\" data-end=\"1775\">Analyze the visual output to identify patterns, variations, and performance differences. Focus on how different segments contribute to overall results and where optimization opportunities exist.<\/p>\n<h3>Step 7: Adding Final Results Visualization<\/h3>\n<p data-start=\"1821\" data-end=\"2145\" data-is-last-node=\"\" data-is-only-node=\"\">Include a final visualization, such as a stacked comparison chart, that highlights how different business units contribute to key metrics, including target achievement, cost efficiency, and revenue contribution. This type of chart makes it easy to compare performance across multiple categories and clearly communicate insights.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-final.jpg\" alt=\"How to Use Sumproduct in Excel\" \/><\/div>\n<h4>Key Insights<\/h4>\n<ul>\n<li>Corporate Sales (35%) and E-commerce (34%) rank first in revenue share, yet neither segment posts particularly high scores for efficiency or target attainment.<\/li>\n<li>Retail stands out as the best all-around performer, recording the top scores for both Target Achievement (i.e., 86%) and Cost Efficiency (81%) across all units.<\/li>\n<li>International trails the field on every measure, posting the lowest revenue share (i.e., 20%) alongside the weakest efficiency and achievement figures in the group.<\/li>\n<\/ul>\n<h2>Benefits of Using SUMPRODUCT<\/h2>\n<p>Choosing to learn how to use SUMPRODUCT in Excel delivers real gains in everyday spreadsheet tasks. Below are the core advantages that come with regular use.<\/p>\n<p>Core advantages include:<\/p>\n<ul>\n<li><strong>Reduces need for helper columns:<\/strong> Completes multi-step calculations within a single formula, keeping worksheets uncluttered.<\/li>\n<li><strong>Performs multiple calculations simultaneously:<\/strong> Multiplies and sums array values in one pass, saving both time and formula complexity.<\/li>\n<li><strong>Handles complex conditional formulas:<\/strong> Assesses several conditions at once without requiring nested IF structures.<\/li>\n<li><strong>Simplifies weighted calculations:<\/strong> Supports proportional modeling and trend work that ties directly into forecasting using Excel.<\/li>\n<li><strong>Enhances reporting efficiency:<\/strong> Improves structured output workflows across the many <a href=\"https:\/\/chartexpo.com\/blog\/ms-excel-uses-in-business\" target=\"_blank\" rel=\"noopener\">MS Excel uses in business<\/a> environments.<\/li>\n<li><strong>Increases formula readability:<\/strong> Brings multiple logic steps into one compact expression that is easier to audit and maintain.<\/li>\n<\/ul>\n<h2>Tips for Using SUMPRODUCT in Excel<\/h2>\n<p>Consistent habits eliminate the most common sources of error. These practices will sharpen your understanding of how to use SUMPRODUCT in Excel and keep results reliable.<\/p>\n<ul>\n<li><strong>Always match array sizes:<\/strong> Every referenced range must share the same dimensions; consistent data formatting in Excel is essential to prevent calculation errors.<\/li>\n<li><strong>Avoid volatile references:<\/strong> Limit the use of frequently recalculating functions that can slow performance across a workbook.<\/li>\n<li><strong>Use parentheses for clarity:<\/strong> Wrap logical conditions explicitly to make the calculation order unambiguous and easy to review.<\/li>\n<li><strong>Combine with IF or other logical functions:<\/strong> Integrate conditional logic inside the formula to extend its filtering and segmentation capability.<\/li>\n<li><strong>Test formulas with sample data:<\/strong> Run the formula against a small subset first to confirm results before applying it to the full dataset.<\/li>\n<li><strong>Document steps for transparency:<\/strong> Add notes to complex formulas and cross-check summaries against <a href=\"https:\/\/chartexpo.com\/blog\/getpivotdata-in-excel\" target=\"_blank\" rel=\"noopener\">GETPIVOTDATA in Excel<\/a> for a reliable audit trail.<\/li>\n<\/ul>\n<h2>FAQs<\/h2>\n<h3>How to use SUMPRODUCT in Excel to calculate a weighted average?<\/h3>\n<p>One practical application of how to use SUMPRODUCT in Excel: enter each score in one column and its corresponding weight in another, nest both ranges inside the formula, and divide the result by the total of the weights column. Each value then contributes proportionally to the final figure.<\/p>\n<h3>Why won\u2019t SUMPRODUCT work in Excel?<\/h3>\n<p>The most common causes are ranges of different lengths, text values mixed into numeric columns, or parentheses placed in the wrong position within a logical condition. Checking that all arrays share identical dimensions and that numeric ranges contain no text will resolve most issues.<\/p>\n<h3>How do you use SUMPRODUCT in Excel to calculate fees by location?<\/h3>\n<p>Add a logical test inside the formula that compares each row\u2019s location field against your target value, then multiply the resulting TRUE\/FALSE array by the fee column. SUMPRODUCT sums only the matching rows, giving you a location-specific total without any helper columns.<\/p>\n<h4>Wrap Up<\/h4>\n<p>Knowing how to use SUMPRODUCT in Excel transforms the way you approach multi-condition analysis. This formula compresses tasks that would normally require multiple helper columns or deeply nested structures into a single, readable expression, giving you faster results and fewer opportunities for error across every project you tackle.<\/p>\n<p>Pair the formula with strong visualization practices, and your outputs become not just accurate but genuinely useful to decision-makers and stakeholders. Start with the examples in this guide, apply them to your own datasets, and build on each technique until working with this formula feels as natural as any other tool in your analytical toolkit.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>How to use SUMPRODUCT in Excel for weighted averages, conditionals, and multi-range calculations. Master the syntax and examples. Read on!<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel\"><\/a><\/p>","protected":false},"author":9,"featured_media":60587,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[746],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Use SUMPRODUCT in Excel: Formula &amp; Insights -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"How to Use SUMPRODUCT in Excel: Formula &amp; Insights -\" \/>\r\n<meta name=\"twitter:description\" content=\"How to use SUMPRODUCT in Excel for weighted averages, conditionals, and multi-range calculations. Master the syntax and examples. Read on!\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-feature.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"zubair\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Use SUMPRODUCT in Excel: Formula & Insights -","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:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel","twitter_card":"summary_large_image","twitter_title":"How to Use SUMPRODUCT in Excel: Formula & Insights -","twitter_description":"How to use SUMPRODUCT in Excel for weighted averages, conditionals, and multi-range calculations. Master the syntax and examples. Read on!","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2026\/04\/how-to-use-sumproduct-in-excel-feature.jpg","twitter_misc":{"Written by":"zubair","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel","url":"https:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel","name":"How to Use SUMPRODUCT in Excel: Formula & Insights -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2026-04-08T06:13:41+00:00","dateModified":"2026-04-08T15:05:40+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/1eda8432f4b1ed2c91fa1ca2a27b536d"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-use-sumproduct-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"How to Use SUMPRODUCT in Excel: Formula &#038; Insights"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/1eda8432f4b1ed2c91fa1ca2a27b536d","name":"zubair","url":"https:\/\/chartexpo.com\/blog\/author\/zubair"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/60572"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=60572"}],"version-history":[{"count":5,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/60572\/revisions"}],"predecessor-version":[{"id":60591,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/60572\/revisions\/60591"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/60587"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=60572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=60572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=60572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}