http://zorba.io/modules/excel/math-sumproduct

View as XML or JSON.

Module implementing the sumproduct functions from Excel 2003 math library. There are 30 functions defined, implementing the same function but with 1 to 30 parameters. Each parameter can be a sequence of infinite length.

Function Summary

sumproduct ($array1 as xs:anyAtomicType*) as xs:anyAtomicType

Sums the values in the sequence.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*, $array27 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*, $array27 as xs:anyAtomicType*, $array28 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*, $array27 as xs:anyAtomicType*, $array28 as xs:anyAtomicType*, $array29 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*, $array27 as xs:anyAtomicType*, $array28 as xs:anyAtomicType*, $array29 as xs:anyAtomicType*, $array30 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumproduct ($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*) as xs:anyAtomicType

Multiplies the elements on the same position in each sequence and sums up the results.

sumsq ($numbers as xs:anyAtomicType+) as xs:anyAtomicType

Returns the sum of the squares of the arguments.

Functions

sumproduct#1

declare  function excel:sumproduct($array1 as xs:anyAtomicType*) as xs:anyAtomicType
Sums the values in the sequence. The sequence can be of any length.

Parameters

array1 as xs:anyAtomicType
the sequence of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum

sumproduct#10

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#11

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#12

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#13

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#14

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#15

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#16

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#17

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#18

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#19

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#2

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#20

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#21

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#22

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#23

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array23 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#24

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array23 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array24 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#25

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array23 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array24 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array25 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#26

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array23 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array24 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array25 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array26 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#27

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*, $array27 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array23 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array24 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array25 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array26 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array27 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#28

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*, $array27 as xs:anyAtomicType*, $array28 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array23 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array24 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array25 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array26 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array27 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array28 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#29

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*, $array27 as xs:anyAtomicType*, $array28 as xs:anyAtomicType*, $array29 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array23 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array24 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array25 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array26 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array27 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array28 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array29 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#3

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#30

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*, $array10 as xs:anyAtomicType*, $array11 as xs:anyAtomicType*, $array12 as xs:anyAtomicType*, $array13 as xs:anyAtomicType*, $array14 as xs:anyAtomicType*, $array15 as xs:anyAtomicType*, $array16 as xs:anyAtomicType*, $array17 as xs:anyAtomicType*, $array18 as xs:anyAtomicType*, $array19 as xs:anyAtomicType*, $array20 as xs:anyAtomicType*, $array21 as xs:anyAtomicType*, $array22 as xs:anyAtomicType*, $array23 as xs:anyAtomicType*, $array24 as xs:anyAtomicType*, $array25 as xs:anyAtomicType*, $array26 as xs:anyAtomicType*, $array27 as xs:anyAtomicType*, $array28 as xs:anyAtomicType*, $array29 as xs:anyAtomicType*, $array30 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array10 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array11 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array12 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array13 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array14 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array15 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array16 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array17 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array18 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array19 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array20 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array21 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array22 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array23 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array24 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array25 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array26 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array27 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array28 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array29 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array30 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#4

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#5

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#6

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#7

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#8

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumproduct#9

declare  function excel:sumproduct($array1 as xs:anyAtomicType*, $array2 as xs:anyAtomicType*, $array3 as xs:anyAtomicType*, $array4 as xs:anyAtomicType*, $array5 as xs:anyAtomicType*, $array6 as xs:anyAtomicType*, $array7 as xs:anyAtomicType*, $array8 as xs:anyAtomicType*, $array9 as xs:anyAtomicType*) as xs:anyAtomicType
Multiplies the elements on the same position in each sequence and sums up the results.

Parameters

array1 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array2 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array3 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array4 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array5 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array6 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array7 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array8 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric
array9 as xs:anyAtomicType
the sequences of numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of products

sumsq#1

declare  function excel:sumsq($numbers as xs:anyAtomicType+) as xs:anyAtomicType
Returns the sum of the squares of the arguments. It used the sumproduct function.

Parameters

numbers as xs:anyAtomicType
the sequence of one or more numbers or arguments castable to numeric

Returns

xs:anyAtomicType
the sum of squared values, as numeric type