Dear Aspose Team,
i am trying to use COUNTIF on an excelsheet:
=COUNTIF(E$6:E$13;“>0”)
this returns 1, however:
=COUNTIF(MyTable[MyColumn];“>0”)
is evalulated properly
MyColumn is a column in my table which is exac…... Mixed data types – A mixture of true numbers...automatically interprets the data type of the column, which can...