Spread for WPF allows you to use array formulas in the worksheets. An array formula performs calculations on one or more items in an array and can return either a single result or multiple results. To create an array formula in a worksheet, you can use the FormulaArray property of the IRange interface.
The following image demonstrates how to create an array formula in the worksheet.
Refer to the following example code to create an array formula in the worksheet.
