Hi,
There is my formula :
=SUMPRODUCT((RIGHT(Data!B2:B1317, 8)="/01/2006")*ISBLANK(Data!H2:H1317))
It works well in Excel, but I can't add it at runtime with Aspose.Cells v4.2.0.0.
Once the spreadsheet opens, the formula returns a value error.
Thanks for your help.
Tom.