Last Updated: 06 Feb 2020 13:07 by ADMIN
Created on: 05 Feb 2020 14:41
Category: Spreadsheet
Type: Bug Report
Sumproduct formula not working in kendospreadsheet

Hi Team,

I am using a kendospreadsheet. I want to find the rownumber of last non blank cell for column C.

When i try the =SUMPRODUCT(MAX(($C$1:$C100<>"")*(ROW($C$1:$C100)))) in excel it works.

The same formula does not work in kendospreadsheet.


Please suggest if this is a bug or if formula needs any change to fit the kendospreadsheet.



Bharathy B

1 comment
Posted on: 06 Feb 2020 13:07

Hello Bharathy,

Thank you for reporting the behavior. I have converted this thread to a bug report. You can track it on this link in our Feedback Portal for further information when it will be fixed.

As a small token of gratitude I am updating your Telerik Points.

Feel free to get back to us whenever you have further questions.

Progress Telerik

Get quickly onboarded and successful with your Telerik UI for ASP.NET MVC with the dedicated Virtual Classroom technical training, available to all active customers.