Common questions about DAVERAGE usually focus on errors, unexpected results, and filling the formula across multiple cells; this section answers 3 frequent questions.
FAQ
What should I do if DAVERAGE returns #VALUE!?
- Check whether the parameter data types are correct and make sure the numeric area does not contain text or extra spaces.
- Check whether the field argument matches the database header.
- If needed, clean the data and enter the formula again.
Why does the DAVERAGE result differ from what I expected?
- Check whether the referenced ranges are correct and make sure the database range and criteria range were selected correctly.
- Check whether the cells used in the calculation are numeric instead of text.
- Review the criteria settings again to confirm that they match the target records.
How can I use DAVERAGE in multiple cells?
- Enter the DAVERAGE formula in the first target cell.
- Select that cell, then drag the fill handle over the target range or copy and paste the formula.
- After filling the formula, check the references and use
$where you need fixed references.
Glossary
| Term | Definition |
|---|---|
| DAVERAGE | A database function that returns the average of records that meet specified criteria. |
| Field | In DAVERAGE, the column used for the average calculation. It can be a column name or a column index. |
| Criteria range | The cell range that defines the filtering conditions used before DAVERAGE calculates the average. |