Skip to main content
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

​
Attribute Description

​
Return Value

​
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.