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

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*, $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.

Variable Summary

Functions

sumproduct#1

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.