I was unable to open the sample due to an assembly reference discrepancy, however I did try the formula in the "FormulaDemo" that comes in the Essentially Studio Sample folder and the formula does not work there either.
For example, if you go to the "Formula Support" worksheet and select an empty cell and type COUNTIF(A:A,"Secondcolumn"), it returns '1' because A24 = "Secondcolumn." But, if you type COUNTIF(A:A,A24) it returns '0'.