This is an ultimate tutorial on criteria use in Sumproduct function in Google Sheets. When you want to learn any function in Google Sheets, the stumbling block between you and the function will be the criteria part. I am sure about this. So this time let us learn how to use text, date, numeric criteria in Sumproduct function with the help of a simple chart. Before that few home work you have to do. What is that?
Learning criteria use will definitely make you a master in using the Sumproduct function. But do you know how to use function Sumproduct?
Sumproduct – Simple & Complex Use
There is no meaning in learning criteria use without understanding the function. So if you are new to Sumproduct you should follow our below link first. Learn the function first and come back. Make sure that you know how to simply use Sumproduct function.
Note: If you want to learn 5 popular Google Sheets functions with plenty of examples, check my eBook below. It details the use of Sumif, Sumifs, Dsum, Sumproduct & Query functions in Google Sheets with plenty of examples. You can use this book as a reference guide to use these functions as there are more than 65 customised formulas ready for reference.
Now back to Sumproduct criteria tips.
How to Use Text, Date, Numeric Criteria in Sumproduct Function
So let me assume you have learned the Sumproduct function already. Now learn how to use text, date, numeric criteria in Sumproduct function in Google Sheets in a crystal clear manner. The below chart is enough for you to learn the use of criterion.
Sumproduct Criteria User Guide – Chart
The first column is about the type of criteria you want to use.
Against Type of criteria, in the second column you can see how to apply the criteria inside a formula.
The third column you can refer when your criteria is in a cell outside formula.
Then what is Same Field Twice in the chart?
One of the advantage of Sumproduct over SUMIFS is the use of same array twice in function. That means you can check multiple criterion in same field. Not clear? Go to the first part of this tutorial where I have given the link to learn Sumproduct. On that tutorial jump to the sub heading “Complex Use of SUMPRODUCT Function in Google Sheets” where I detailed the multiple criteria use in same fields in Sumproduct.
Enjoyed the above criteria tips?