Excel Sumproduct with Multiple Criteria

In this video, I will going to show you how I use Sumproduct when there are multiple criteria.

First example is the usual 2 criteria, in cases using and asterisk or double negative to convert Boolean into 1s or 0s.

Second example is similar to the first one but handle an array of values instead of a row (or column) range.

Third example is the handling 2 criteria with dates which uses the YEAR() function. Two ways are presented, one with helper cell and the other has none. The last part in example 3 is handling 3 criteria with dates. Three ways are presented, one with helper, one with three criteria, and lastly, one with combined criteria converting it into 2 criteria placed in a SUMPRODUCT ().

Link to download the sample file:

Link on a youtube video for Index & Match and Sumproduct

Link on a youtube video for Sumproduct in Excel (Several ways to use Sumproduct):

Thanks for your time and I hope you learn something from it. 😊

Help me to reach my target audience by sharing my videos with the right people. 😊

Don’t forget to Subscribe! 😊