AVERAGE in WPS on Windows FAQ

When using the AVERAGE function, common questions usually involve formula entry, argument ranges, unexpected results, and key terms; this section includes 4 FAQs and 4 glossary items.

FAQ

Why does the AVERAGE function not return a result?

1. Check whether the formula starts with =.
2. Check whether the function name is entered as AVERAGE.
3. Check whether the parentheses, separators, and cell references are complete.
4. Press Enter again to confirm the formula.

Why is the result different from what I expected?

1. Check whether the calculation range includes the wrong cells.
2. Check whether the referenced cells contain numeric values.
3. Check whether helper data that should not be counted is included in the formula.
4. Update the formula and confirm the result again.

Can AVERAGE calculate more than one range at the same time?

1. Yes. You can include multiple arguments in one formula.
2. For example, enter =AVERAGE(A1:A5,C1:C5,10).
3. Press Enter to calculate the average across multiple ranges and constants together.

Does the average update automatically after I change the source data?

1. Yes. The formula result updates when the referenced data changes.
2. If the result does not change, check whether you edited the correct referenced cells.
3. If needed, edit the formula again to confirm the calculation range.

Glossary