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.
Tag Archives | SUMPRODUCT
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…..
Here are a couple more great uses of SUMPRODUCT in Excel…..
Here’s how we can use SUMPRODUCT instead of SUMIF in Excel when adding columns of data based on a certain criteria…..