Excel - The SUMPRODUCT function

Ask a question



Description : Calculates the product of the arrays specified in the formula and then summing up these products.
  • Syntax : SUMPRODUCT (array1,array2,array3 ...)



Statistical functions: COUNTIF
Excel - The substitute function