AVERAGEA in WPS Spreadsheet: Average Numbers, Text and Logical Values

• Introduced: documented by 2019-06-05 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; no numeric release is stated in the edition metadata.
• Scope: exact current supported builds remain unverified. The Windows lesson does not establish equivalent availability in other WPS clients.
• Checked: October 14, 2026 against function-specific documentation. Examples were independently calculated; no native WPS test was performed.

=AVERAGEA(value1, [value2], ...)

Provide at least one value or reference. The dated Windows Personal lesson describes 1–30 arguments; the maximum in a current build has not been verified. Square brackets indicate optional arguments and are not typed.

Examples use English function names and comma separators. Create a separate sheet, store numbers as numbers and leave output cells outside the inputs. The type distinctions below concern referenced cells; they do not establish every direct-argument conversion rule.

Enter this control in A2:A8. The descriptive columns are explanations, not additional formula inputs.

=AVERAGEA(A2:A8)

Expected result: approximately 30.166666667, calculated as (80+100+0+1+0+0)/6. There are seven positions but only six included observations. Do not divide by the physical range height without checking its contents.

For comparison, =AVERAGE(A2:A8) has expected result 90 because the documented referenced-range rule for AVERAGE uses only the two numeric cells. Neither result is automatically the correct business measure: choose the function whose treatment matches your policy.

In a copy of the first control, clear A4 completely:

=AVERAGEA(A2:A8)

The expected result becomes 36.2, or 181/5. The sum is unchanged, but one zero-contributing observation has been removed. Replacing Absent with the actual number zero instead leaves the original result at approximately 30.166666667.

Clearing both A4 and A7 leaves 80, 100, TRUE and FALSE as four observations, giving 45.25. Replacing a formula returning empty text with a genuinely empty cell can therefore change the mean even when both look blank.

A text label such as Absent may mean missing information rather than a zero score. AVERAGEA applies its calculation rule; it does not decide which interpretation is fair or appropriate.

In C2:C4 enter numeric 10, the text value ‘100, and numeric 20. The leading apostrophe is an entry instruction used to store 100 as text.

=AVERAGEA(C2:C4)

Expected result: 10, from (10+0+20)/3. Converting C3 into the actual number 100 changes the expected mean to approximately 43.333333333. Changing only its display format does not establish that its stored type changed.

This example does not certify a formula such as AVERAGEA("100") with direct quoted text. The source explicitly describes text inside an array or reference, so keep that distinction when investigating imported values.

In E2:E6 enter =TRUE(), =TRUE(), =FALSE(), a genuinely empty cell and ="":

=AVERAGEA(E2:E6)

Expected result: 0.5, or two ones divided by four included observations. Clearing the empty-text formula changes it to approximately 0.666666667. It is a proportion of true outcomes only if the included observations genuinely represent the intended population.

Do not mix arbitrary numeric scores into this control: a value such as 5 contributes five, so the mean would no longer describe a Boolean success rate. COUNTA can help inspect occupied cells but does not validate that every entry is a Boolean.

Group one contains 10 and 20, giving an AVERAGEA mean of 15 from two observations. Group two contains 30, 40, Absent and a genuinely empty cell, giving approximately 23.333333333 from three included observations.

An unweighted average of the two means is approximately 19.166666667. The combined five-observation mean is instead:

=(15*2+(70/3)*3)/(2+3)

Expected result: 20, matching the sum 100 divided by five. Keep unrounded group means for the calculation. Different physical range sizes and ignored cells make it unsafe to assume equal denominators.

The lesson establishes the displayed type and blank distinctions, but not a complete native error, coercion or all-empty-range table. This guide therefore does not silently turn errors into zero or assign an unverified error code to every invalid input.

Use AVERAGEIF for a documented single-condition selection, rather than inserting text labels into a numeric range and assuming they will be ignored by AVERAGEA. All worked results here are independently calculated expectations, not captured application output.

• WPS Academy: AVERAGEA lesson, 2019-06-05 (Chinese; Windows Personal scope).
• Editorial testing standards.

Worked outputs are independently calculated expectations, not captured native results. The dated source establishes the stated product scope, not every current client or build.