In this tutorial we are going to look at how to filter and sum up a column of data that has multiple criteria in both rows and columns using two options – either the SUMPRODUCT function or the SUMIFS function.
Tag Archives | SUMPRODUCT
In this tutorial we’ll explore how to use the SUMPRODUCT function to divide arrays and add them rather than multiplying those arrays.
In this tutorial we are going to use IF, SUMPRODUCT, and ISNUMBER to figure out the difference between summing values that add up to zero vs. summing blank cells in Excel.
In this tutorial we are going to use the IF and SUMPRODUCT functions to determine if a series of courses or requirements have been completed for a student or employee. We will also use Conditional Formatting to make the results more visual.
Let’s compare these three ways of creating a summary chart from our raw sales data to see which is more preferable…..
Here is a follow up post based on a question I received on my previous post about SUMIF & SUMIFS…..