Sumif

Aspose.Cells Product Family
1

Hi

I am having a problem with the SUMIF statement.

workbook.Worksheets[0].Cells["W1"].Formula = "=SUMIF(C2:C7,\"=John\",D2:D7)";

The formula works ok in Excel, but when running the code I get the error message

Exception Details: Aspose.Cells.ExcelException: Length cannot be less than zero.
Parameter name: length"=SUMIF(C2:C7,"=John",D2:D7)".

Any ideas please ?

Thanks

James

2

Hi James,

Well I tested SUMIF formula in accordance with your line of code and It's perfect to show the desired result. Which version of Aspose.Cells you are using? I am using 4.0.3.3

If you have further queries, kindly let us know.

Thanks for your consideration.

Regards

Amjad Sahi

Aspose Nanjing Team

3

Hi Amjad

I am using version 4.0.1.0, I will update to the latest version and check

Thanks

James

4

Thanks! The problem disappeared with the latest release.

James