COVARIANCE.S in WPS on Windows FAQ

Last updated:July 17, 2026

Review 3 common questions about COVARIANCE.S, including formula errors, function guidance, and unexpected results.

FAQ

What should I do if COVARIANCE.S shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Confirm that the parentheses, separators, and number of arguments are correct.
  3. Review the referenced ranges for content that cannot be used in the calculation.
  4. Press Enter again after making corrections.

How can I view guidance for the COVARIANCE.S function?

  1. Type =COVARIANCE.S( in a cell.
  2. Look at the function hint shown in the editing area.
  3. Use the hint to confirm the required argument order.

What should I do if the COVARIANCE.S result looks incorrect?

  1. Check whether referenced cells contain numbers stored as text.
  2. Confirm that the two data ranges correspond correctly and contain a reasonable sample size.
  3. Review the formula for circular references or incorrect references.
  4. Update the data and check whether the result changes as expected.

Glossary

TermMeaning
COVARIANCE.SA statistical function used to calculate sample covariance.
Cross-sheet referenceA formula reference to a cell or range on another worksheet.
Nested formulaA formula that includes another function or expression inside it.
Automatic recalculationFormula results refresh automatically when referenced data changes.