Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.



The COVARIANCE.S function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

  • Array1     Required. The first cell range of integers.
  • Array2     Required. The second cell range of integers.


  • The arguments must either be numbers or be names, arrays, or references that contain numbers.
  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
  • If array1 and array2 have different numbers of data points, COVARIANCE.S returns the #N/A error value.
  • If either array1 or array2 is empty or contains only 1 data point each, COVARIANCE.S returns the #DIV/0! error value.
Applies to:
Excel 2010, Excel Web App