Surpass provides a very simple style to pull out data from databases to perform in demand functions over it. It as wel provides lean of functions which can be used exclusively for databases, you just want to create a database or undecomposable table and let Excel screw to view it as one absolute database, define some criteria to extract specified entries. Excel DCOUNT subprogram lets you to count the occurrence of specified data if the criteria is met.
Launch Excel 2010 spreadsheet connected which you postulate to apply database functions, e.g. we have included a spreadsheet containing fields; Name calling, Of course, and Marks connected which we will be applying DCOUNT role.
For applying database functions, we need to create a new table having the criteria connected which we volition equal evaluating functions. In the same spreadsheet create a table by the diagnose of Criteria, as shown in the screenshot below. Make sure that the airfield labels in the this postpone essential be assonant As in the other table.
Straight off we wish be evaluating database DCOUNT function. To start off with, we will be creating a DCOUNT label beneath the table.
The DCOUNT function will grant the count of the students who met the nominative criteria i.e >60. The syntax of DCOUNT function is;
=DCOUNT(database,field,criteria)
The first argument in the table is database which refers to location of database table in the spreadsheet, next argument landing field refers to the column/athletic field total in database mesa, and criteria refers to whatsoever criteria which need to be met, it can be either location of cells or statement defining criteria.
We will be penning this as;
=DCOUNT(A1:C10,3,E3:F4)
A1:C10 in the table is location of the cells which makes astir database, 3 is the number of the column in the database defer (Marks) for which we accept defined criteria, and E3:F4 is the location of Criteria table. On evaluating this occasion, it wish yield 6, every bit at that place are 6 students in summate who have bonded marks greater than 60.
Now if you want to check that in how many courses, specific student secured Simon Marks greater than 60 then you just motivation to enter the name of the student in the Criteria table, It will take out-out all the same data for the specified name and yield result 2, As you can project in the screenshot under there are alone two courses in which specified student has secured marks greater than 60.
You potty also check out previously reviewed Stand out part; Logical Functions, INFO, SUMSQ, Dollar mark, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.
Excel 2010: DCOUNT Function
Source: https://www.addictivetips.com/microsoft-office/excel-2010-dcount-function/
