Database

DAVERAGE Function in Excel

Returns the average of selected database entries that match specified criteria.

Syntax

  • =DAVERAGE(database, field, criteria)

Arguments

  • database (required): Range including headers
  • field (required): Column to average (name or number)
  • criteria (required): Range with criteria headers and values

Examples

  • =DAVERAGE(A1:D10, "Sales", F1:F2) - Average sales matching criteria - Result: Average value

D-functions vs DAVERAGE

  • Database functions use a criteria range with headers matching your list.
  • For simple AND criteria [SUMIFS](/functions/sumifs/) may be easier to audit.
  • Compare [SUMIF vs SUMIFS](/compare/sumif-vs-sumifs/) for reporting patterns.

Common errors

  • Field name must match header exactly
  • Criteria range needs headers

Use cases

  • Database analysis
  • Conditional averages
  • Report summaries

Frequently asked questions

  • What is DAVERAGE and when should I use it? DAVERAGE calculates the average of values in a database column that match criteria. Use it for complex multi-column criteria that AVERAGEIF can't handle. It's ideal for structured data with headers.
  • What is the difference between DAVERAGE and AVERAGEIFS? AVERAGEIFS uses criteria directly in the formula. DAVERAGE uses a separate criteria range, making complex OR conditions easier. DAVERAGE is better for changing criteria; AVERAGEIFS is simpler for fixed conditions.
  • How do I set up OR criteria in DAVERAGE? Put OR conditions in separate rows of the criteria range. For 'Sales OR Marketing' department: put 'Department' header in F1, 'Sales' in F2, 'Marketing' in F3. Each row is an OR condition.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.