In Spreadsheet, Sumproduct does not behave as in Excel.

[martintabakov]

Bug report

The Sumproduct formula does not work as in Excel when used to find the row index of the last non-blank cell in a column.

Reproduction of the problem

1. Open this Dojo - https://dojo.telerik.com/@sspasova/aSodIHuJ
2. Apply formula - =SUMPRODUCT(MAX(($A$2:$A20<>"")*ROW($A$2:$A20)))

Current behavior

The formula returns #VALUE! instead of the correct row index.

Expected/desired behavior

The formula should return the index of the last non-blank cell - 14.

Environment

• Kendo UI version: 2023.3.1114
• Browser: [all]