In this tutorial I am not going to explain how to use DSUM function. It’s already explained! You can find some rare and useful DSUM tutorials by using the search option on this site. Here my topic is different. Here I am going to tell you how to properly use criteria in DSUM, whether it should be within quotes, without quotes or in any other specific format?
When we think about the proper use of criteria, definitely there are two main aspects involved in it. What are they? The first one is using criteria within formula and the second one is using criteria as cell reference. In this Google Sheets tutorial let us learn how to properly use text, numeric and date criteria in DSUM function.
The use of text, numeric as well as date criteria in DSUM and another similar function SUMIFS is slightly different. That you can find by following the Google Sheets tutorial link below.
Google Sheets: How to Properly Use Criteria in DSUM
I have prepared a table chart for you to use as a reference whenever you have trouble using criterion in DSUM.
=DSUM(database, field, criteria)
See the criteria part in the syntax. I will explain you how to properly use text, numeric and date criteria here. Use the below chart for this. To learn the function as I have already told you, please search on this site with search term “DSUM”.
In the above DSUM criteria usage chart;
Type: the type of criteria – text, numeric or date.
Within formula: The criteria format when we use it within formula.
As a cell reference: The criteria format when the criteria as a reference to any cell.
The above chart will be helpful for you in the following cases.
- Proper use of Text Criteria in DSUM with in formula.
- Proper use of Text Criteria in DSUM as cell reference.
- Proper use of Date Criteria in DSUM with in formula.
- Proper use of Date Criteria in DSUM as cell reference.
Numeric Value as Criteria:
- Proper use of Numeric Value or Number as Criteria in DSUM with in formula.
- Proper use of Numeric Value or Number as Criteria in DSUM as cell reference.
Also you can see how comparison operator used with criteria in DSUM.
If you liked this tutorial you may please bookmark this page for your future reference.