Count based on multiple criteria

Function DCOUNT(), the English version of the DCOUNT(), counts the rows in the data table that satisfy the given conditions.

SKATESLIME(), the English version of COUNTIFS() designed for counting rows, fields which satisfy the two criteria and more.

SUMPRODUCT(), the English version of SUMPRODUCT(), is not as simple as it seems at first glance: in addition to the sum of works, this function can be used to count and sum values based on criteria, and, in some cases, eliminate the need of applications of array formulas.

Function DCOUNT(), the English version of DCOUNTA(), calculates text values in the data table that satisfy the given conditions.

will give the count of values that meet three criteria, which form the Conditions I. 2 for Example, in a table with a list of Fruits and their quantities in stock, will select rows where the column Fruit is Apples, and the balance in stock of at least 4 (boxes) and not more than 90.

the Count of numbers included in the interval – standard task: use the function SKATESLIME(). Let's complicate the task, let's do interval is easily configurable.

are counting the table rows that meet three criteria, which form the Condition OR the Condition I. for Example, in a table with a list of Fruits and their quantities in stock, will select rows where column is Fruit Peaches OR Apples, and with the balance in stock of at least 10 (boxes). 

are counting the rows of a table whose values satisfy the two criteria that form OR Condition. For example, in a table with a list of Fruits and their quantities in stock, will select rows where the column Fruits is Peaches OR row of the residue of stock not less than 57 (boxes). Ie Party Peaches are selected anyway, and they added party any fruit with balance of stock not less than 57 (bins).

are counting the rows that match two criteria, which form the Condition I.