Translations:Documentation/Calc Functions/DCOUNT/147/en

From The Document Foundation Wiki
Jump to: navigation, search

count of rows of distance to school where distance to school is greater than 600 so we want to know how many children have to travel more than 600 meters to school. If the result is to be stored in cell B16. Set the cursor in cell B16. Enter the formula =DCOUNT(A1:E10;D1;A13:E14) in B16. The Function Wizard helps you to input ranges. Database is the range of data to be evaluated, including its headers: in this case A1:E10. DatabaseField specifies the column for the search criteria: in this case, the column with the numerical distance values. SearchCriteria is the range where you can enter the search parameters: in this case, A13:E14.