{"id":201,"date":"2020-06-19T00:01:57","date_gmt":"2020-06-18T22:01:57","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=201"},"modified":"2024-05-03T23:27:20","modified_gmt":"2024-05-03T21:27:20","slug":"advanced-sumproduct-function-sum-multiple-criteria","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-sum-multiple-criteria\/","title":{"rendered":"Advanced Excel SUMPRODUCT Function: Sum Multiple Criteria"},"content":{"rendered":"

What does it do?<\/strong><\/em><\/p>\n

It returns the sum of multiple criteria from the corresponding ranges or arrays.<\/p>\n

Formula breakdown:<\/strong><\/em><\/p>\n

=SUMPRODUCT((array 1 criteria) *<\/span><\/span>\u00a0(array2 criteria) *<\/span><\/span>\u00a0array values<\/span>)<\/p>\n

What it means:<\/strong><\/em><\/p>\n

=SUMPRODUCT((find my criteria in this array) *<\/span><\/span>\u00a0(find my criteria in that array) *<\/span><\/span>\u00a0return the values from the values array<\/span>)<\/p>\n

\n

The SUMPRODUCT function<\/a> is my favorite Excel function by a stretch!<\/p>\n

You can create some powerful calculations with the EXCEL SUMPRODUCT function by creating a criteria for a selected array.<\/h4>\n

For example, you can see how much sales your sales rep did in a particular region and for a particular quarter without having to create a Pivot Table<\/a>.<\/p>\n\n

It takes some practice to get comfortable with Excel SUMPRODUCT multiple criteria function<\/a> but when you master it, it opens up another Excel world!<\/p>\n

Let’s understand how to use\u00a0this function to sumproduct multiple columns.<\/p>\n

\n