If you use a formula combined with a database function, you need the formula to point to the first data cell in the relevant table column. Let's say you have the text value "Criteria" in cell A1, you then need the formula directly below that in A2.
Specifying the criteria allows you to limit or filter the records (rows) that are included in a database function's calculation. Although criteria is a required part of the syntax of a database function, you can set it to "blank" so that all records in a database are included in the calculation.
The DGET function will now have the criteria data embedded inside the formula and the sales details of the salesperson will be displayed in the cell. The final formula will look something like this – =DGET(Sales1, “Sales”, I14:I15) How to use the DGET Function in Excel In this article, we will learn about how to use the DGET function in Excel. DGET function is built-in database function in Excel.
Because the equal sign is used to indicate a formula when you type text or a value in a cell, Microsoft Excel evaluates what you type; however, this may cause unexpected filter results. To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range: This Excel tutorial explains how to use the Excel DCOUNT function with syntax and examples. The Microsoft Excel DCOUNT function returns the number of cells in a column or database that contains numeric values and meets a given criteria.