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…...– You can: Select the range, go to Data → Text to Columns , click...