Averaging and Extracting With DAVERAGE and DGET

This lesson covers two final database functions:

• DAVERAGE - the average of a numeric field for matching records.
• DGET - pulls a single value from the one row that matches your criteria.

Both reuse the same (database, field, criteria) pattern you already know, so you are mostly learning what they return, not new syntax.

DAVERAGE(database, field, criteria) takes the mean of the field column across rows that match the criteria range.

• database - full table with headers.
• field - a numeric column to average.
• criteria - the matching rules block.

It is like AVERAGEIFS, but reads conditions from cells.