How to Use the DAVERAGE Function in WPS on Windows

Last updated:July 20, 2026

Use DAVERAGE through 1 how-to topic, including entering the function and completing a conditional average calculation; choose a topic from the index and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Use the DAVERAGE functionFree

How-to Guide

1. Use the DAVERAGE function

Entry path: Formulas tab → formula bar

  1. Open WPS Spreadsheets and select the cell where you want the result to appear.
  2. Type an equals sign = in the formula bar or directly in the cell.
  3. Type DAVERAGE( and review the syntax prompt that appears.
  4. Enter the database range, field, and criteria range in order.
  5. Type the closing parenthesis and press Enter to display the result.

Success Criteria

  • Interface result: The target cell shows the DAVERAGE calculation result.
  • Next actions available: You can continue editing arguments, copying the formula, or filling it into other cells.

Tips While Using

  • Common mistake: If the criteria range does not include field headers, the result may not match your expectation.
  • Environment note: When referenced ranges change, the result recalculates with the updated data.