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.

Appears in

No references yet.