DAVERAGE in WPS on Windows: Introduction

DAVERAGE in WPS on Windows is a database average function in WPS Office Sheets; it covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	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 database function in WPS Office Sheets on Windows. It is used to calculate the average of records that meet specific criteria, which is useful for spreadsheet data calculation and analysis.

Core capabilities include:

Enter the DAVERAGE function quickly and complete a calculation.
Fill in the database, field, and criteria arguments correctly.
Use cross-worksheet references and nested calculations.
Update results automatically after source data changes.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local function calculation does not require a constant internet connection; downloading, installation, and account services require network access
Other	You need to open WPS Sheets files and have permission to edit cells and formulas

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office, open Sheets, and confirm that you can enter DAVERAGE from the Formula tab or the formula bar

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports the DAVERAGE function in WPS Sheets to calculate the average of database records that meet criteria, with cross-worksheet references, nested calculations, and automatic recalculation.	Excel provides the `DAVERAGE(database, field, criteria)` syntax to average values in records that match specified conditions.	Google Sheets provides the `DAVERAGE(database, field, criteria)` syntax to return the average of values selected from a database-style range by criteria.	Notion tables support Average calculations for number properties and formula properties for numeric logic, but they do not provide a spreadsheet-style DAVERAGE function.	Acrobat supports calculated PDF form fields and predefined calculations such as average, but it does not provide spreadsheet database functions.
WPS Advantages	Advantage: You can use the DAVERAGE syntax directly in WPS Sheets for conditional averaging, while also working with cross-worksheet references and automatic recalculation in everyday spreadsheet analysis.	Compared with WPS: Excel offers a directly comparable database function workflow for spreadsheet users already working in Microsoft 365.	Compared with WPS: Google Sheets also supports the same function name and syntax, with a stronger browser-based collaboration focus.	Compared with WPS: Notion is centered on database views and property calculations rather than direct spreadsheet database function entry.	Compared with WPS: Adobe calculation features are designed for PDF forms instead of general spreadsheet formula editing.
Official Source	—	DAVERAGE function	DAVERAGE	Table view	Configure form field calculations in Acrobat

Overall Conclusion
If your main task is to calculate the average of database records by criteria in a spreadsheet, WPS, Microsoft Excel, and Google Sheets all provide a direct function-based approach. Notion and Adobe are better suited to database presentation or PDF form calculation scenarios, while WPS fits routine spreadsheet formula editing and automatic result updates.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Average values in filtered sales data	Sales teams, operations teams	Need to calculate the average for a specific group of orders by condition	Use DAVERAGE with a criteria range to filter records and return the average
2	Analyze student scores	Teachers, academic staff	Need to calculate average scores by class or subject conditions	Set up a criteria range in WPS Sheets and use DAVERAGE
3	Summarize finance data	Finance staff	Need to average data after filtering by project or department	Use the field argument together with the criteria range
4	Analyze data across worksheets	Data coordinators	Data is spread across multiple worksheets and manual averaging is inefficient	Use cross-worksheet references and automatic recalculation

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
DAVERAGE function entry and calculation	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited quantity	More content available
Some advanced tools	May be limited depending on the page or feature	Broader access to advanced tools

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Learning spreadsheet functions and handling basic calculations	Free version	DAVERAGE itself is available without membership for routine data analysis
Needing more cloud storage and broader advanced tools	WPS Member	Suitable if you also use more document, PDF, template, and cloud service features

WPS membership center: Subscribe now