COVARIANCE.S in WPS on Windows FAQ

Last updated:July 16, 2026

When using COVARIANCE.S in WPS Spreadsheet, common questions usually involve formula errors, result checking, and reuse across cells; this FAQ covers 3 frequent questions.

FAQ

What should I do if COVARIANCE.S returns a #VALUE! error?

  1. Check whether the referenced ranges contain text, extra spaces, or other non-numeric content.
  2. Confirm that the selected cell ranges are correct and do not include unrelated values.
  3. Clean the data if needed, then enter or confirm the formula again.

Why does the COVARIANCE.S result look different from what I expected?

  1. Check whether the two referenced ranges match each other correctly.
  2. Confirm that you are using the sample covariance function COVARIANCE.S instead of another statistical function.
  3. Review the original data format and make sure numbers are not stored as text.

How can I use COVARIANCE.S in multiple cells?

  1. Enter a correct COVARIANCE.S formula in the first target cell.
  2. Drag the fill handle or copy and paste the formula into other target cells.
  3. Check whether relative and absolute references are set as intended, and use $ when you need to lock references.

Glossary

TermDefinition
COVARIANCE.SA statistical function used to calculate the sample covariance of two data sets.
CovarianceA statistical value that describes how two data sets change in relation to each other.
Argument rangeThe cell range or data set used as an input in a formula.