DAVERAGE in WPS on Windows: Introduction

DAVERAGE in WPS on Windows is a spreadsheet database function for averaging values that match specified criteria; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

DAVERAGE is a built-in database function in WPS Spreadsheets on Windows. It is used to calculate the average of values in records that meet specified criteria.

Core capabilities include:

Entering =DAVERAGE( directly in a worksheet cell.
Filling in the database, field, and criteria arguments with syntax guidance.
Using cross-sheet references and nested calculations.
Recalculating results automatically when referenced data changes.

This function is useful for conditional average calculations in sales tables, inventory sheets, score reports, and similar datasets.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local formula calculation
Other	You need to open WPS Spreadsheets and edit worksheet cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Launch WPS Office → open Spreadsheets → select a cell and confirm that you can enter a formula

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports DAVERAGE in WPS Spreadsheets for averaging values in database-style records that meet criteria, with syntax guidance, cross-sheet references, and automatic recalculation.	Excel provides the DAVERAGE function with the syntax `DAVERAGE(database, field, criteria)` to average values in records that match specified conditions.	Google Sheets provides DAVERAGE with the syntax `DAVERAGE(database, field, criteria)` to average values selected from a table-like range using criteria.	Notion formulas can perform calculations with database properties, built-ins, and functions, but they are not spreadsheet-style DAVERAGE database functions.	Adobe Acrobat supports calculated fields and form logic in PDF forms, which fits form workflows rather than worksheet database functions.
WPS Advantages	Advantage: You can enter DAVERAGE directly in a worksheet cell for conditional average calculations. Distinct: It fits spreadsheet workflows where the result can continue to work with other worksheet functions.	Compared with WPS: Excel offers the same function name and similar syntax, which fits users already working in Excel-based workflows.	Compared with WPS: Google Sheets also supports DAVERAGE, but it is centered on a browser-based spreadsheet environment.	Compared with WPS: Notion focuses on database property formulas and does not provide a direct DAVERAGE-style worksheet function.	Compared with WPS: Adobe calculation features are designed for PDF form fields instead of general spreadsheet database analysis.
Official Source	—	DAVERAGE function	DAVERAGE	Intro to formulas	Advanced form fields

Overall Conclusion
If your work is centered on spreadsheet analysis, DAVERAGE in WPS is a practical way to calculate conditional averages directly in a worksheet. Microsoft Excel and Google Sheets provide comparable database functions, while Notion and Adobe are oriented toward database-property or PDF-form scenarios instead of spreadsheet database formulas.

Use Cases

No.	Scenario	Suitable For	Core Need	How DAVERAGE Helps
1	Sales average by condition	Sales teams, operations staff	Calculate average order values after filtering by conditions	Use DAVERAGE with a criteria range to average matching records
2	Score analysis	Teachers, academic staff	Calculate average scores by class or subject	Set a criteria range in the score sheet and use DAVERAGE
3	Inventory review	Warehouse and purchasing teams	Calculate average stock levels by category or location	Use the database, field, and criteria arguments for conditional averages
4	Financial review	Finance staff	Check average values for records that meet specific rules	Combine DAVERAGE with other statistical functions
5	Cross-sheet analysis	Data coordinators	Reference data and criteria across worksheets	Build the formula with cross-sheet ranges

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
DAVERAGE function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
More PDF and advanced value-added features	Some limits apply	More features are available

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday spreadsheet formulas	Free	DAVERAGE itself is available for regular worksheet calculations
Broader office needs beyond formulas	WPS Premium	Suitable if you also need more PDF, template, cloud, or other extended features

WPS membership center: Subscribe now