Definition

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

Sample Usage

Syntax
SUMPRODUCT(array1, [array2, ...])
  • array1 - The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.
  • array2, ... - [ OPTIONAL - {1,1,1,...} with same length as array1 by default ] - The second array or range whose entries will be multiplied with corresponding entries in the first such array or range.
Notes
  • Matrix multiplication, MMULT, can also be accomplished using a combination of TRANSPOSE and SUMPRODUCTfunctions.
See Also
TRANSPOSE: Transposes the rows and columns of an array or range of cells.
MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.
 
In order to use the SUMPRODUCT formula, start with your edited Excellentable:
 
 
 
 


  
    
      



    

        
        Error.
    

    
User does not have sufficient privileges to access this Content 
Learn More