How to Use the DAVERAGE Function in WPS on Windows

Last updated:July 17, 2026

Use DAVERAGE through 4 task topics, with 4 available without membership and 0 membership-related items; choose a topic from the How-to Index and follow the steps to complete it.

How-to Index

#TopicMembership
11. Enter the DAVERAGE functionFree
22. Fill in the function argumentsFree
33. Use cross-worksheet referencesFree
44. Check automatic recalculationFree

How-to Guide

1. Enter the DAVERAGE function

Entry point: Formula tab → formula bar

  1. Open WPS Sheets and select the cell where you want to display the result.
  2. Type = to start editing a formula.
  3. Enter DAVERAGE(.
  4. Check the syntax prompt and confirm that the function name is correct.

Success Criteria

  • UI state: =DAVERAGE( appears in the cell or formula bar.
  • Next actions: You can continue entering the database range, field, and criteria arguments.

Tips While Using

  • Common mistakes: If you do not type = first, the content may be treated as plain text.

2. Fill in the function arguments

Entry point: formula bar

  1. After DAVERAGE(, enter the database range.
  2. Type a comma and enter the field name or field number.
  3. Type another comma and enter the criteria range.
  4. Type the closing parenthesis ) and press Enter.

Success Criteria

  • UI state: The target cell returns a calculation result.
  • Next actions: You can revise the arguments and calculate again.

Tips While Using

  • Common mistakes: Unmatched parentheses or missing separators between arguments can cause a formula error.

3. Use cross-worksheet references

Entry point: formula bar

  1. While editing the DAVERAGE arguments, switch to the worksheet that contains the source data.
  2. Select the database range or criteria range.
  3. Return to the worksheet with the result cell and confirm that the reference address has been inserted into the formula.
  4. Press Enter to complete the calculation.

Success Criteria

  • UI state: The formula includes worksheet reference addresses.
  • Next actions: You can modify data in the referenced worksheet and observe the result change.

Tips While Using

  • Common mistakes: An incomplete reference range can affect the criteria filter or the average result.

4. Check automatic recalculation

Entry point: result cell with DAVERAGE already entered

  1. Change the source data in the database range or edit the criteria range.
  2. Check whether the result cell updates automatically.
  3. If it does not update immediately, press F9 to recalculate.
  4. Confirm that the result matches the current criteria.

Success Criteria

  • UI state: The result cell updates when the data changes.
  • Next actions: You can continue adjusting criteria and repeat the analysis.

Tips While Using

  • Common mistakes: Numbers stored as text or circular references may cause unexpected results.