DAVERAGE
A Database Function that returns the average of a field over the records that match the criteria, with the form =DAVERAGE(A1:J201,J1,AC236:AE238).
When to use
In the class example it gave the average salary (8116.86) of employees whose position begins with Support or assistant, with seniority under 12 and hired after 1 January 2000. The two position words sit on different rows (OR) and the other conditions repeat on each row (AND).
See Lec 01.