http://www.zorba-xquery.com/modules/excel/math-sumproduct

import module namespace excel = "http://www.zorba-xquery.com/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.

Daniel Turcanu

xquery version "3.0" encoding "utf-8";

• the XQuery module can be found here.

Imported modules:

• http://www.zorba-xquery.com/modules/excel/math

For more details please also see:

• Excel 2003 Documentation: Math-sumproduct Functions

sumproduct

declare function excel:sumproduct (
            $array1 as xs:anyAtomicType* 
 ) as xs:anyAtomicType

Sums the values in the sequence. The sequence can be of any length.

• $array1 the sequence of numbers or arguments castable to numeric

• the sum

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

• sumproduct1.xq

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric
• $array7 the sequences of numbers or arguments castable to numeric
• $array8 the sequences of numbers or arguments castable to numeric
• $array9 the sequences of numbers or arguments castable to numeric
• $array10 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric
• $array7 the sequences of numbers or arguments castable to numeric
• $array8 the sequences of numbers or arguments castable to numeric
• $array9 the sequences of numbers or arguments castable to numeric
• $array10 the sequences of numbers or arguments castable to numeric
• $array11 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric
• $array7 the sequences of numbers or arguments castable to numeric
• $array8 the sequences of numbers or arguments castable to numeric
• $array9 the sequences of numbers or arguments castable to numeric
• $array10 the sequences of numbers or arguments castable to numeric
• $array11 the sequences of numbers or arguments castable to numeric
• $array12 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric
• $array7 the sequences of numbers or arguments castable to numeric
• $array8 the sequences of numbers or arguments castable to numeric
• $array9 the sequences of numbers or arguments castable to numeric
• $array10 the sequences of numbers or arguments castable to numeric
• $array11 the sequences of numbers or arguments castable to numeric
• $array12 the sequences of numbers or arguments castable to numeric
• $array13 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric
• $array7 the sequences of numbers or arguments castable to numeric
• $array8 the sequences of numbers or arguments castable to numeric
• $array9 the sequences of numbers or arguments castable to numeric
• $array10 the sequences of numbers or arguments castable to numeric
• $array11 the sequences of numbers or arguments castable to numeric
• $array12 the sequences of numbers or arguments castable to numeric
• $array13 the sequences of numbers or arguments castable to numeric
• $array14 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

• sumproduct2.xq

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

• sumproduct3.xq

sumproduct

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.

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

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric
• $array7 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric
• $array7 the sequences of numbers or arguments castable to numeric
• $array8 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumproduct

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.

• $array1 the sequences of numbers or arguments castable to numeric
• $array2 the sequences of numbers or arguments castable to numeric
• $array3 the sequences of numbers or arguments castable to numeric
• $array4 the sequences of numbers or arguments castable to numeric
• $array5 the sequences of numbers or arguments castable to numeric
• $array6 the sequences of numbers or arguments castable to numeric
• $array7 the sequences of numbers or arguments castable to numeric
• $array8 the sequences of numbers or arguments castable to numeric
• $array9 the sequences of numbers or arguments castable to numeric

• the sum of products

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092931033.aspx

sumsq

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.

• $numbers the sequence of one or more numbers or arguments castable to numeric

• the sum of squared values, as numeric type

• excel-err:Value if the parameters cannot be casted to numeric type

• http://office.microsoft.com/en-us/excel/HP052092951033.aspx

• sumsq1.xq