DAVERAGE in WPS on Windows FAQ

When using DAVERAGE, the most common questions fall into 3 areas: formula entry, unexpected results, and usage scope; this section covers the top 3 questions.

FAQ

What should I do if DAVERAGE returns an error after I enter it?

1. Check whether the formula starts with =.
2. Make sure the parentheses are paired correctly.
3. Confirm that argument separators are entered correctly.
4. Verify that the database range, field, and criteria range are all filled in correctly.

What do the DAVERAGE arguments mean?

1. database is the range that contains field headers and record data.
2. field is the column to average, and it can be a column label or a column index.
3. criteria is the criteria range used to filter which records are included in the average.

Why does the result look incorrect?

1. Check whether the criteria range includes the correct field headers.
2. Check whether the field argument points to the column you want to average.
3. Check whether the referenced cells contain data types suitable for calculation.
4. If you use cross-sheet references, confirm that the referenced ranges have not shifted.

Glossary