How to Use

This guide includes 3 how-to topics for DAVERAGE in WPS Spreadsheets, and all 3 are available without membership.

How-to Index

How-to Guide

1. Insert DAVERAGE from the Insert Function dialog box

Entry point: Formula tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for DAVERAGE in the dialog box.
4. Select the function and confirm.
5. Fill in each parameter in the Function Arguments dialog box.
6. Confirm to insert the function.

Success Criteria

• Interface result: The target cell contains a DAVERAGE formula.
• What you can do next: You can continue editing parameters, confirm the formula, or copy it to other cells.

Tips While Using

• Make sure the function name is entered as DAVERAGE.
• Confirm the database range, field, and criteria range before filling in parameters.

2. Type a DAVERAGE formula directly in a cell

Entry point: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =DAVERAGE(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review parameter guidance, type =DAVERAGE( and press F1 to view syntax help.

Success Criteria

• Interface result: The cell shows the calculated result or the entered formula.
• What you can do next: You can continue editing, fill the formula down, or copy it to other cells.

Tips While Using

• Separate parameters with commas.
• When copying the formula, check whether relative and absolute references are set as intended.

3. Review DAVERAGE syntax and parameter guidance

Entry point: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Search for DAVERAGE.
3. Select the function to review the syntax: DAVERAGE(...).
4. Click the help link for more details.

Success Criteria

• Interface result: You can view syntax and parameter guidance for DAVERAGE.
• What you can do next: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

• Check the parameter order and referenced ranges carefully.
• If the result looks incorrect, review the field name and criteria range settings in the worksheet.