SUMPRODUCT function

description:

Returns the sum of the products.

 

syntax:

=SUMPRODUCT( array1[array2], …)

 

required arguments:

array1 The text string.

 

optional arguments:

[array2] The maximum number of characters that is returned.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.