How to use Excel COVARIANCE.S Function


COVARIANCE.S function in excel is a statistical function. This function is used to find the sample co-variance of two data sets. For example it can be used to keep  check on how to assets are moving together. This is a worksheet function and can be entered into the cell in which count is required.


=COVARIANCE.S(Array1, Array2)


Array1: 1st range of cells.

Array2: 2nd range of cells.


  • The arguments used should be numbers or range of cells containing numbers
  • If the range of cells contains text values, logical values, or empty cells than they are ignored but cells containing 0 are used.
  • If the arguments contain different set of data points than #N/A error is displayed.
  • If any of the argument is empty, #DIV/0! Error is displayed.


In this example, various values are entered in Column B and Column C and Column D, and COVARIANCE.S function is used to find co-variance between values in column C and D which gives 0.00028 as the result.

Leave a Comment

Your email address will not be published. Required fields are marked *