Excel Database Functions In Pashto - BETTER than SUMIFS, COUNTIFS etc.!DATABASE FUNCTION

Описание: 0:00 Introduction
0:22 Database Function Syntax
1:27 Database Function Example - Multiple AND Criteria
3:33 Database Function Example - Multiple AND OR Criteria
4:22 Database Function Example - Multiple OR Criteria, Same Field
4:52 Database Function Example - Multiple OR Criteria, Different Field
5:45 Database Function Example - Wildcards
6:39 Database Function Example - DGET Function
7:37 Database Function Rules

CAUTION: The multiple OR criteria on different fields example (4) will aggregate all data which is level 1, including level 1 for Atkins (because the name field is blank on the first criteria row), plus all other levels except those that are for Atkins (because the Type field is blank on the second criteria row). Caution: it will double count Level 1 not equal to Atkins and this is probably not what you want.