I am having a problem with the SUMIF statement.
workbook.Worksheets.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 ?