> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# SUMPRODUCT

> The SUMPRODUCT function performs array calculations and returns the sum of products. It is available across multiple YiDA scenarios, including forms, workflow design, and integration & automation. The function accepts one or more arrays as parameters, and all arrays must contain the same number of elements.

The **SUMPRODUCT** function performs array calculations and returns the sum of products. It multiplies corresponding elements across multiple arrays and then sums all the products.

## Supported Product Scenarios

The SUMPRODUCT function is supported in the following YiDA scenarios:

* Form (main form field)
* Form (business association rule)
* Form (validation)
* Workflow design (validation rule)
* Workflow design (association action)
* Integration & automation
* Workflow node
* Connector

## Format

```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
SUMPRODUCT(array1,array2...array5)
```

## Attribute Description

| Attribute | Required | Description                                                                                                                                                                                              |
| --------- | -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| array     | Yes      | Array type. One or more arrays, ranges, or references to include in the calculation. Separate multiple arrays with commas.<br />**Note**: All parameter arrays must contain the same number of elements. |

## Return Value

| Return type                                     | Description                                 |
| ----------------------------------------------- | ------------------------------------------- |
| Double-precision floating-point number (Double) | The result of the multiplication operation. |

## Example

As shown below, use the `SUMPRODUCT()` function to calculate the total amount of a purchase order.

## Try It Out

Multiplies the corresponding elements across the given arrays and returns the sum of the products.