Invalid Formula using COUNTIF

Aspose.Cells Product Family
1

Hello,

I want to use this formula but without success :
Invalid formula:"=COUNTIF('IMES++ SPAR Overview Report'!G2:G779;"Estimated")".


Piece of code :
w.Cells[j, 1].Formula = "=COUNTIF('" + dataSheet.Name + "'!" + columnName + "2:" + columnName + i + ";\"" + w.Cells[j, 0].StringValue + "\")";


What is the problem ?
Thanks !
Dji.

2

Formula can only be delimited by ',', not ';'. So please change your code to:

w.Cells[j, 1].Formula = "=COUNTIF('" + dataSheet.Name + "'!" + columnName + "2:" + columnName + i + ",\"" + w.Cells[j, 0].StringValue + "\")";

And please use this attached version.